Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
I have a macro that upgrades a spreadsheet for a new weeks input. All it
actually does it moves down present weeks sales to the past weeks sales and I have the new week with empty cells. The weeks are in the columns, Mon-Fri, and the sellers are in the rows. Several cells are Merged and every day has a separate column for the accumulative sales for that day. The spreadsheet also has If formulas for every day that prevent the spreadsheet to count the accumulative for more days than Today's date. Simple so far. I've used this spreadsheet for a year, but now I get an error message when I run the macro. It give a number of reasons why the file couldn't be accessed and the one that blows my mind is: Make sure the file name does not contain any of the following characters: < ? [ ] : Statsgrid, macro.xls. "Statsgrid, macro.xls" is the name of the master file for this worksheet. ????? Thank in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
Something has changed. Macros don't run for a year then
just start giving error messages. Something has changed to make the macro give error messages. Is it the same message(s) all the time or different ones each time. think. what changes did you make to the file or macro just prior to the macro start giving the error messages. -----Original Message----- I have a macro that upgrades a spreadsheet for a new weeks input. All it actually does it moves down present weeks sales to the past weeks sales and I have the new week with empty cells. The weeks are in the columns, Mon-Fri, and the sellers are in the rows. Several cells are Merged and every day has a separate column for the accumulative sales for that day. The spreadsheet also has If formulas for every day that prevent the spreadsheet to count the accumulative for more days than Today's date. Simple so far. I've used this spreadsheet for a year, but now I get an error message when I run the macro. It give a number of reasons why the file couldn't be accessed and the one that blows my mind is: Make sure the file name does not contain any of the following characters: < ? [ ] : Statsgrid, macro.xls. "Statsgrid, macro.xls" is the name of the master file for this worksheet. ????? Thank in advance. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
I know that I have not changed anything in the VBA codes, possibly some
other changes I don't know I've done. When this msg first appeared I simply recorded a new macro and renamed the file. That worked out fine. One time! Now I'm getting the same error message as before, but with the new file name instead. I am getting the same error message all the time. One time I simply unprotected the sheet after the error msg, right clicked on the macro button, choose edit the macro, but didn't do anything just closed the VBA window and run the macro in an unprotected sheet. That worked, but I found some data had got lost and it was too early to run to run the macro. I closed the workbook and didn't save. Next time I opened the workbook I got the same error msg when I run the macro the first time. This macro exists in 5 workbook and saves me some great amount of time. It is very important for me. Even if I made a change in one workbook, the next week I'm opening a new workbook from the template with a fresh macro. What I don't understand is why I get an error msg about a file that is just stored together with other masters. That file does have the original code, but it is not actively used, just stored. Thanks wrote in message ... Something has changed. Macros don't run for a year then just start giving error messages. Something has changed to make the macro give error messages. Is it the same message(s) all the time or different ones each time. think. what changes did you make to the file or macro just prior to the macro start giving the error messages. -----Original Message----- I have a macro that upgrades a spreadsheet for a new weeks input. All it actually does it moves down present weeks sales to the past weeks sales and I have the new week with empty cells. The weeks are in the columns, Mon-Fri, and the sellers are in the rows. Several cells are Merged and every day has a separate column for the accumulative sales for that day. The spreadsheet also has If formulas for every day that prevent the spreadsheet to count the accumulative for more days than Today's date. Simple so far. I've used this spreadsheet for a year, but now I get an error message when I run the macro. It give a number of reasons why the file couldn't be accessed and the one that blows my mind is: Make sure the file name does not contain any of the following characters: < ? [ ] : Statsgrid, macro.xls. "Statsgrid, macro.xls" is the name of the master file for this worksheet. ????? Thank in advance. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |