On one computer, when I open Excel 2010 templates it doesn't open it in Excel. It previews in my explorer window as shown in this screenshot but doesnt open but on another computer it will open as normal.
I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.
I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.
You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)
Turn off your preview pane, which is that square box on the upper right. That should disable the preview and open the document in Excel.
I want to save a new template under excel office. The error message is "Progfile (X86)\microsoft office\office14\xlstart\book.xltx You dont have permission to save to this location. Contact Administrator to obtain permission."
I am the administrator. I am the only user account setup. What is causing this problem?
Enter the .reg key into your registry by double clicking on it and then navigate to the said folder or object you are trying to save to and right click on it and "take ownership" of the folder or object. Then try and save it again. Hope this helps,
Hi, I'm hoping someone can help, I have an excel spread sheet, which when I plot the graphs, plots blanks as zero values.
I've tried the hidden cell options etc. File Attached to show the issue.
Apologies if itís me being stupid!
I try an use #N/A, as a chart normally will ignore #N/A - see Office Overall OEE
so I try to make any formulas evaluate to IF(your formula is true, your formula,#N/A)
is that Dummy data ,as the forum is public
I have a user using Excel 2010 when he opens a Excel file in our sharepoint site and does a save as it does not go to the location the file is saved the path in the save as box is his local machine. All of our users that have office 2007 do not have this issue. I have configured his trust settings to allow saving to the sharepoint site to no avail. I am about to tell him he needs to revert to 2007 but would rather solve the issue first. Any help appreciated I am beating my head against the wall
Hi! THaygood, welcome to 7F
Does this make any sense?
My IT Experiences: Issue with Save to SharePoint in Excel 2010
I have a .txt file that is imported into Excel using delimiters("^").
I look at the .txt file, and do not see anything different/out of place, but when I import it into Excel 2010, some of the lines end up with a "=" attached.
.txt Excel 2010
- Three monitors =- Three monitors (resulting in #NAME?)
Why is an "=" inserted into the import?
I have attached some screenshots to demonstrate.
See if setting import step 3 "Column data format" to "Text" helps. Otherwise, need more information about your source material and import parameters.
Column A will not display and column B will partially display on my monitor. They are there; they display on print preview and I can send the cursor to an A or B cell, it simply does not display. When I left click on the horizonal scroll arrow, it only takes me to column C. Go figr.
Sounds like the Auto-Adust button on the monitor might need tapping.
My Outlook 2010 on a Windows 8.1 machine will not launch an excel attachment correctly. It just loads excel, no document at all.
I can save the document and view it, and I can see the mini-preview in outlook itself. But if I double click on the attachment, it just loads excel with no document.
I'v checked the trust center settings and they all appear to be in-line.
Please advise and thanks for your time in advance,
anyone?Read other 1 answers
I have some very large spreadsheets ( 7000K to 11150K in size ).
These were developed using Excel 2007 on a Windows XP 32-bit 2GByte RAM computer.
Encountered out of resoucres error message when trying to copy and paste formulae and formats.
Concluded computer did not have enough memory so upgraded to computer with
Intel Quad Processor
8 Gbytes RAM
Windows 7 64-bit
Excel 2010 64-bit
Problem still persists.
Spreadsheets have a great deal of conditional formating rules
Also a very large number of defined NAMES local to individual worksheets
Each spreadsheet ( workbook ) has approx 125 - 185 separate worksheets
Most have identical structure - each referiing to a particular date so data varies.
Huge number of formulae in each worksheet.
Can anyone give me some clues as to what is going on inside Excel 2007 / 2010?
I'm not sure, I have large spreadsheets myself and no issues and my computer has less memory but maybe if you disable automatic calculation before running the macro's and turn it on afterwards it will help?
See link below for some code indication.
I turn off events when I change a sheet until the process is complete and turn it on afterwards
Application.EnableEvents = False
Application.EnableEvents = True
I don't know if it will make a difference for you, but it won't hurt trying it.
Don't forget to make a backup before you do it.
I am having an issue with internet explorer and excel files (xlsx file) with data links to other excel workbooks.
When i open an excel file from a network share (\\server\share\excel.xlsx) without going through internet explorer, i typically get a pop up asking to update /refresh the data.
However when i try to open the same file through a link on a website in internet explorer the excel file just opens and i do not get prompted to update the document. once the file is opened in excel 2010 and if i go to data - edit links - and click "check status", the status of the links is "warning: values not updated", if i then choose each link individually and click "open source" (they open fine) then close them, hit check status again, both links now say "Ok"
if i completely close excel then open excel with no opened files, and again attempt to open the link through ie, i do get prompted to update and everything is okay, if i check the status of the links, they both say "OK".
if i go into excel and file, options, advanced and remove the checkmark to "ask to update automatic links", ie opens the excel file fine, i am not prompted to update, however the check status shows as "OK". so i am assuming it is updating them, however just without prompting, which i something i do not want to occur, i want people to be aware they are updating the document.
the location to the files (both the file itself and where the... Read more
Hi all, sorry for the direct registration and straight to question, but this is doing my head in ;
I have been using excel pivot table and charts for years and have never come across this issue before and I have no idea whats going on,
I have a very simple pivot table taken from an excel spreadsheet, the table has figure for three years titled as 2011-2012, 2012-2013, 2013-2014, and periods I to 12,the table looks fine, but when I create a chart from this table the lines for the years periods are added up, so P1 2011-2012 shows the figure of 20k, then the P1 line for year 2012-2013 takes the figure from the chart and adds the figure for P1 2011-2012 and so up for all the periods (months) I don't understand how this has happened or what I need to do for the period and year to just show on the chart what is shown in the table..
any help would be appreciated as I need to present this in the morning
Hi Paul, welcome to the forum
I noticed nobody has answered you.
I don't know if I can help but if you have a sample file, could you please attach it for me to take a look at so see if I can find a reason?
Make sure sensitive data is changed but a table with values will do.
Add a screenshot of what you encouter and how it should look too.
I think I've run into another unexplainable issue (again):
Public Sub PSetup(ws As Worksheet)
' PSetup Macro
If isProcessedFile = False Then Exit Sub
Dim origScreenUpdating As Boolean
Dim pRange As String
origScreenUpdating = Application.ScreenUpdating
Application.ScreenUpdating = False
Dim sActivePrinter As String
sActivePrinter = Application.ActivePrinter
Dim origCalcMode As XlCalculation
origCalcMode = Application.Calculation
Application.Calculation = xlCalculationManual
On Error GoTo HandleErrors
pRange = "$A1:" & ws.Cells.SpecialCells(xlCellTypeLastCell).Address
ActiveSheet.PageSetup.PrintArea = ""
If Application.Version >= 14 Then Application.PrintCommunication = False
.PrintTitleRows = "$1:$4"
.PrintTitleColumns = ""
.PrintArea = pRange ' "$A1:" & ws.Cells.SpecialCells(xlCellTypeLastCell).Address
.LeftMargin = Application.InchesToPoints(0.551181102362205)
.RightMargin = Application.InchesToPoints(0.551181102362205)
.TopMargin = Application.InchesToPoints(0.984251968503937)
.BottomMargin = Application.InchesToPoints(0.984251968503937)
.HeaderMargin = Application.InchesToPoints(0.511811023622047)
.FooterMargin = Application.InchesToPoints(0.511811023622047)
.PrintHeadings = False
.PrintGridlines = False
.PrintComments = xlPrintNoComm... Read more
Read other 8 answers
Hi, I've got something that keeps going wrong.\
I have a large file which I use at work to register and plan my colleague's tasks and resgiter (outside our regular vacation/sick/abscence, etc.) the different calls they are working on allocating this. But that works, that's not the issue.
I have a sheet named "Medewerkers", yes it's Dutch for Employees of Colleagues.
I extracted and stripped this portion. (June 16: removed this attachment, correct attachment in final post)
On this sheet double clicking in Column A on the name will open a userform to edit this one or if you double click the first empty row below it you get a blank form to enter the data.
Since I regularly ran into problems useing the ....ocx calendar picker I wrote my own date picker and it works. Using son supporting code I found the funtion GetDateInLocalFormat() does it's job.
But now the issue:
The person on the sheet has as starting date 01-03-2012 (in Dutch format this March 1, 2012) and ends August 2012
On my system and at work The date pickers selects it correctly, show is and the userfrom shows it as 01-03-2012 but when I press 'Vastleggen" (Commit) the date is saved as 03-01-2012 which in Dutch January 3, 2012 when I double click again the datpicker shows the default data as January 3, 2012.
The cell's format is dd-mm-yyyy;@ the system's settings are for code 31 which is Dutch and I have pasted screen shost of the settings that show this.
I... Read more
I changed my code a littel and instead of passing the date in local format I pass it as a serial date and then there is no doubt and the result is correct. But if somebody can offer a better solution, I'm all eyes and ears, and ... maybe it will help others who struggel with date values and the international settings
Hello Techies: I'm looking for an easier way to have a table checklist (it was copied and pasted to email from Excel) on outlook that's emailed to me daily to be a saved template on Outlook as opposed to the person sending it to me to go back into the previous email and write over previous data?
This is a checklist a person does everyday and updates a grid like table which I had copied into an outlook email. The subject is always the same so I have a folder rule whereby these daily emails are stored. The person goes into the previous day's email and copies the grid/template to a new email with the same subject tittle and enters the new data. I wonder if I can save a template of that grid so whenever the person clicks new email the template/grid automaticallly appears with the same subject tittle, thus avoiding the extra work of copying from an old email?
I created the following outlook template and would like to auto update <yesterdayís date> everytime I open my template. Any idea?
Subject: daily report for <current date>
The first attachment is for <yesterday's date>
The second attachment is also for <yesterday's date>
The third attachment is for <today's date>
We currently switched from WordPerfect to Word 2010. In WordPerfect we had a macro for the letterhead where you typed in your information (or picked from a drop down list in some places) and then it would bring up your document for you to continue typing in. I need to set up the same thing in Word and thought of using forms etc. but I want to keep it as close to the WordPerfect way as possible.
Does anyone have any ideas on how I can acheive this?
Tech Support Guy System Info Utility version 184.108.40.206
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i3-2120 CPU @ 3.30GHz, Intel64 Family 6 Model 42 Stepping 7
Processor Count: 4
RAM: 4011 Mb
Graphics Card: DameWare Development Mirror Driver 64-bit, 5 Mb
Hard Drives: C: Total - 57138 MB, Free - 18546 MB;
Motherboard: Intel Corporation, DQ67SW
Antivirus: ESET Endpoint Antivirus 5.0, Updated and Enabled
I am relatively new to VBA so please bare with me.
The company I work for has multiple business divisions and each business has multiple branch locations.
The letter template needs to allow the user to select their business division in a combobox in a userform which will populate that field in a table in the footer.
I then need to populate the address and contact details, also contained in a table in the footer. I would like this information to be pulled from an excel spreadsheet which will allow for updates by administrators who may have very basic level knowledge of Word. The other option, I believe, is to use docvariables, but I am unsure of how they work. I can only assume that the information is manually entered into the userform and that the document remembers the information?
Any assistance is greatly appreciated. Thank you in advance.
Can you post a sample letter showing how the completed letter should appear?
According to the site below and a few others, the template folder is at
BET: Microsoft Word Templates - Normal.dot
C:\Documents and Settings\"user name"\Application Data\Microsoft\Templates\
I'm using Windows 7 64 bit and there is no Document and Settings Folder in Windows 7.
I can't find a Templates Folder in App Data either.
Please help, thanks.
"C:\Users\username\AppData\Roaming\Microsoft\Templates\Normal.dotm"Read other 2 answers
I just picked up an Acer Iconia Tab W500 series tablet pc
It has Microsoft Office Starter 2010 and I'd like to create a Word template without upsetting the default template or any others
Can you help me figure out how to do that?
I found a link to work on what I'd like to work with
Learn about templates in Office 2010
Okay, so when I use a template for an email, it messes the whole thing up. Colors disappear, font changes, even bolding and underlining vanish, and I believe links no longer work. That is once it is sent, the "draft" everything looks perfect.
However I can take all the text from a template and put it in a new email and it will send as it should. I can even Forward the copy in my Sent Folder in Outlook and it will forward it as a Good email with no mess ups.
I could really use help with this as it is a nuisance when doing 10 or 20 emails based off of templates... I have tried to recreate the same templates but still have no luck with them. They were originally made with Outlook 2k3 if it matters.
Outlook1.jpg is how it looks before sending and how it should turn out..
Outlook2.jpg is how it gets sent back to me and anyone else viewing the email..
Maybe something in this link will clarify the matter for you:
How to Create and Use Templates in Outlook 2010 - How-To Geek
Or perhaps this one:
Send an email message based on a template - Outlook - Office.com
Ok, so I created a custom template and saved it as such (.dotx). And when I want to use it, I go File>New>My Templates>APA Format.dotx. All of that is fine, and the template works fine.
My question: can I have my custom template show up NEXT to the My Templates folder, Blank Document template, etc. Right now that top row of Available Templates has: Blank document, Blog post, Recent templates, Sample templates, My templates, and New from existing. I want to simply add my custom template to this row of options. That would allow me to select New> APA Format.dotx.
If you need a better explanation, please ask.
I appreciate any and all help!
Nobody knows how to do this?Read other 3 answers
I'm stuck and need help! I am currently trying to create an RFI log and want to use a template for the RFI request. I have two worksheet in Excel - one for the template, the other as a log. I am trying to figure out how I can lookup the next available number in the log and reflect that on the template.
Read other 6 answers
I remembered how to creat an excel template, but cant remember how to force it to save as xls, rather then saving it as a template.
The problem I have is that the template is saved in a folder and other users need to be able to access it, now when a template is not in the default location, when you save it will save as a template rather then a spreadsheet.
Does any one of you guys know of a way around this?
I have to use excel 2003
Thanks for reading!
I edited the original post with some additional info
I am trying to create a template from a spreadsheet. I found instructions
which say to go to "file" then "save as" then "template." I cannot find
"template" anywhere in the "save as" option.
Which version of Excel?
2007 would be .XLTX older .XLT in the save as dialog box.
I am looking for an Excel template that i could us as an old inventory cardex. I want to use this to track the movement of about 200 rental items. Any suggestions?
can you provide details of what information you want to keep and track - there are lots of templates available on the net
and i usually do not do this - but I think in this case a google search would probably be the best option
if you can provide enough detail someone here may create a template
I have been getting the following errors in Excel 2010 for about 3 months and they are getting more frequent (I have Win 7 Pro):
(1) Errors were detected while saving 'C:\Users\username\Documents\filename.xlsx'.
Microsoft Excel may be able to save the file by removing or repairing some
features. To make the repairs in a new file, click Continue. To cancel saving the
file, click Cancel.
(2) Cannot open the Clipboard.
(3) An unexpected error has occurred. AutoRecover has been disabled for this session of Excel.
(4) Excel has stopped working.
(5) Freezes on print preview.
I have done the following:
- Tried Excel in safe mode.
- Uninstalled and Reinstalled Office 2010.
- Disabled all add-ins.
- Done an exhaustive search on the internet only to find that other people have one or more of these errors, but no solutions.
- Other Office 2010 apps work ok.
Nothing has worked. Iím barely able to get anything done! Please help, Iím dying here!
Read other 16 answers
I am trying to make Avery 5168 Labels but get this message:
"The margins, label size, and number across or down values produce a page that is larger than the label page size."
I'm not entering my own custom label sizes here - I'm selecting an Avery label from Word's own list. After selecting the Avery product I click on Details. There I can go down to page size and select Letter or Letter Landscape. Both are 8.5 x 11", but for some reason Landscape gets me the error message.
I have already set my document to Landcape in page layout thinking that might be the problem but that didn't fix the issue.
Any ideas? Thanks, H.T.
This Avery website may be useful for you as there is a program download there for creating Avery labels.
Avery Wizard | Microsoft Office 2013 | Mail Merge | Labelling | Avery Australia & New Zealand
This is my first post in this forum. I found this forum on the web looking for a template. Hope everyone will forgive my poor typing skills.
I am looking for an Excel spreadsheet or phone call log template whereby I could download my long distance telephone bill from a website, and paste it into a spreadsheet. I then have a sheet of frequently called numbers, which automatically pastes the person's name who called that number into the spreadsheet and tallies everything for that person. (Windows XP, Office 2003) I already checked MS Online.
>> forgive my poor typing skills
Didn't notice any.
>> I already checked MS Online
I don't know of any ; let's make one!
>> download my ... telephone bill ... and paste it into a spreadsheet
The numbers & amounts go in columns A & B respectively of the "Calls" sheet.
>> sheet of frequently called numbers
See table on "FCNs" sheet.
>> which automatically pastes the person's name ... into the sheet
The formula in column C of "Calls" looks up the UserName (from the FCNs table) for the number. You'd just need to copy it down as far as the list goes.
>> tallies everything for that person
There's a pivot table on the "Summary" sheet for this. To update it, you just rightclick it & choose "Refresh Data" from the pop-up menu.
Download the file, change the extension to xls, then check it out. Post back with how it needs tweaking to fit your needs.
Does Excel have a file associated with it similar to Word and normal.dot? When I open Excel I have 2 projects listed in the project window of the VB editor. AUTOSAVE.XLA and FUNCRES.XLA. Both are password protected. Are these 2 projects a normal part of Excel? If not how can I get rid of them?
those would be add-ins. Go to tools, Add-ins and uncheck them from there.
I've been using this particular mileage template from Microsoft extensivley to record mileage used. It has the ability to record mileage, and keep a running total. Well, the running total stopped working. I know that its probably an easy fix, but I just can't figure it out. I'm using Office 2007. I thank any one in advance that is able to help me.
Read other 8 answers
I am trying to create a template to save time when counting devices on drawings. However I guess I have too many formulas or the range to too big, because when I go to calc the workbook. It locks up for about five minutes. Any suggestions?
Read other 16 answers
Hello, please tell me what I am looking for. Once I have a name I'll dig into my reference books and the Help screens and it will make sense.
I would like to create a worksheet/template/style(generally one 8.5 x 11 page) that has unchanging text across the top, column A is filled with solid color. I'll use this as a "master" in creating 20 pages that have a uniform visual appearance.
The blank space down and to the right will have simple 8 or 10 row and 5 or 6 column "worksheets", or text. When I "print preview" I would like this material to center h/v. The text across the top and column A would not be impacted.
I don't know what Excel calls this sort of thing and so I'm at a lost to know what to study.
Read other 10 answers
I have constructed a template which contains my own customised toolbars which are very different to the usual toolbars and saved as an .xlt file in :-
Documents and Settings\user_name\Application Data\Microsoft \Excel\XLstart.
However whenever I try to use this template I get the usual toolbars and not my customised set.
This is causing me much consternation !!!.
I would be most grateful for any suggestions as I am obviously doing something very wrong.
Read other 16 answers
Hi Tech support guy,
Hope all are going fine here
i need a help to do some work in excell, well i will explain
i am having an excell file, where i updated all departments email contact details.
when i click on any particular email, i need to open lotusnotes on to:that particular email, cc: another email address, and a common temlpate in body of message, where i will fill manually,
i added the email address and subject in hyperlink , but i dont know how to go for other fields such as 'cc' and 'message of body'
Message of the body just contains
Please help me guys,
Thankyou so much in advance
it would be constructed like this.....
[COLOR="Red"]mailto:[/COLOR][email protected];[email protected]?[COLOR="Red"]cc=[/COLOR][email protected]&[COLOR="Red"]subject=[/COLOR]subjectmsg&body=Bodymsg
I am looking for a template to use in Excel that will allow me to sort my contacts/sales leads. Right now I am just saving all of my notes in various forms (word documents, excel, outlook contacts), and its a mess!! I was hoping there was an easy way to enter the information about the contacted company and the individual(s) within the company I have spoken with, and a space for tracking the status. My dream of course is to just run a report or show a graph of my progress. But as for now, I just really need a template to easily enter the information so that I can share it.
Does anyone know where to find one? I feel like I've Googled my heart out....
Thank you in advance!!!!
Read other 16 answers
is there any way to link a template with all the spreadsheets which are created from it, such that whenever i make changes to the template it will update all the spreadsheets at the same time. i am trying avoid having to change each spreadsheet separately as i refine the original design.
if there some other way to accomplish this without using a template, eg. using sheet1, sheet2, etc on the same spreadsheet, that would be ok as well.
Hi, I just thought I'd pose this question, I don't even know if it's possible.
I work at a t-shirt company and we create sheets for each order we do, showing all the sizes for each shirts, their totals, and then under that two pictures, the front of the shirt and the back.
Some of these designs we do quite a bit of and up until now the girl doing these has imported each picture by hand using corel draw and printing it out, and then filling in the totals by hand.
I thought it might be possible to create a template that lets her just type in the numbers of each size shirt that will automatically give her a total and, more importantly, I was hoping there was a way to have her be able to simply type in a letter (our t-shirt fronts are labeled by letter) of the front and have the program automatically put in the picture she was referencing when it prints out. I thought if I told excel where the pictures were and make the letter in that cell reference a specific one it would be possible. I don't know anything about excel, however, so I don't know how to go about doing it.
Is this possible? How would it be done if it is? Any help would be greatly appreciated.
Read other 11 answers
Okay, so I've been assigned a task to make an excel sheet for our clients to use to input their invoice information. The file I'm creating will then be converted into pipe delimited and uploaded to a third party server [why they demand pipe delimited, I don't know]. The third party software is very particular about how it reads the file so I need all the cells to have the proper formatting.
I need to control what goes into a cell, for instance payment type may only be the 1 of 8 possible options. I can't trust the clients to fill in the spreadsheet correctly so what's the best way to make sure they can only enter proper formats into cells?
The follow thread to this will be, what's the best way to convert this file to pipe delimited. I was just going to write a macro that saved it in CSV then opened it in word and replaced the commas with pipes. All suggestions are welcome.
Read other 16 answers
I am running Word 2010 on a PC, running Windows 7.
I cannot figure out how to make changes to the "normal" template and have those changes apply to old word files.
In old versions of Windows and Office, I used to be able to make changes to the normal template by going in through the Appdata, and the changes that I made would be reflected in both new documents created, and old documents when selecting "normal" as a text style. However, now I cannot even make changes to the normal template by going through file locations and saving changes.
I can only make changes to the normal quick style icon (by right clicking on "modify" and then applying all changes to "new documents based on this template.") However, this does not alter the "normal" quick style icon in files saved prior to making the changes to the normal template. How can I get my updated normal template to apply to all documents, not just new ones?
OR- maybe there is another solution...
The reason I need the normal template to apply to all documents is that in the new word, I cannot copy and paste and maintain source formatting (even when pasting special and selecting "keep source formatting".) The paste always takes on the destination style, and if the destination style has a "normal" template that is different from the source "normal" style, it automatically selects the destination style and WILL NOT keep source formatting. I have ... Read more
I have an Excel sheet that contains data per row (employee data). I want data contained in each cell of each row be put in a Word template (a work agreement)
I see something close to what I need here, but I tried to manipulate the codes for hours and achieved nothing.
Please find enclosed the Excel file and the Word template that I need. These are dummy files as forum rules rule out.
Thanks in advance for your assistance
Before we go into any macro development, have you tried the mail merge option in word?
With mail merge you need an excel file with your data formatted as a list - which you already have
then you need to define where you want each record in your excel file should appear in your word document - which you've already done although you should make sure that your list starts in row 1
in Word you need to associate the excel file with the Word template - in the Mail ribbon - Select Recipients/Use existing list and then navigate to where your excel file is an select it
then you need to enter the "variables" in your word document - I've done this or you in the attached
then you need to just select the record you want to run - Click on Edit Recipient list and click on the one you want
and click Finish and Merge and then either Print or Edit (if you want to save a copy)
Give this a try and see if it will suit your needs.
I have an easy question. I have already looked at several examples on the web and in this forum but don't seem to have the simple solution I am looking for.
I have a form in Access where the user will select parameters and then click a button to preview the report (which I have done already) or another button to export the query to excel. I am able to export the query to a new file using the output to or the transferspreadsheet, however, I want to export the data to an excel template file.
There will be only 1 query to export and I just want it to go into the template Sheet 1 or whatever I want to name it, and then have the user save the file as an .xls. This way my template file will always be available and the user can name it what they want. I don't want to link the file as I saw that solution in another thread.
If you have any suggestions please let me know. By the way, I am not very good with VBA so please go easy on me.
Read other 7 answers
Have a procedure that is being used where large amounts of data are copied from Excel template to individual templates for users.
Wrote a macro to perform this task, worked perfectly for a few minutes, and then the formatting was off for the individual spreadsheet; the individual performing is again copying and pasting.
Other than picking up empty spaces in the macro, what else could be wrong?
Here is the macro:
'This macro copies all visible data from the source file to the create file, removes any excess rows/columns/formatting,
' deletes any sheets from the create file if no data is present, and renames the create file to the manager's name
' so that it's ready to be mailed to them
'Ranges need to be modified for each new set of data. They have been included in the comments for convenince for using
' find and replace throughout this page. A2 should always been the starting point for manager data. If
' multiple headers exist within a single sheet, delete all but 1 row for this macro to function properly.
' Only the end range should need to be changed. This should indicate the last row containing data for each sheet.
' Ranges in this function need to be updated to match the ranges called in each sub
'Oracle Range("A2:... Read more
Hi, welcome to the forum
Nice code etc etc etc, but I don't think you realized that nobody is going to copy this and then try and figure out all the sheet names and so to test and troubleshoot.
If I read it correctly and seing that the excel file has the xlsx extension I assume at least Excel 2007.
I suggest you upload a copy of the file with dummy data or at least non-sensitive private dat in it so that we can try to figure out what the problem is.
A pice of advice when writing macro code: never hardcode filepaths into your code, everytime the location changes you have to go back to the drawing board.