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.


.