Excel macro error msg..

[lauricat]

Hi

I get the following msgbox when I attempt to run a Macro - which is just a
simple text string to be put into a cell.

" 'xxx'.xls could not be found. Check the spelling of the file name, and
verify that the file location is correct.
If you are trying to open a file from your list of most recently used files
on the file menu, make sure that the file has not been renamed , moved or
deleted." (ok)

'xxx.xls' trefers to a file name that was on my disk - but I deleted - I
can't find it after a search.

All macros when run, exhibit the same thing.....

Tried a google no help..

Any help gratfully appreciated. Got me stumped..

Thanks.
Laurie.

 

[Frank Kabel]

Hi
you may post the code of your macro. maybe you reference the old file

 

[Bob Umlas]

Maybe the text you're putting in has an "=" in front? If you enter =xxx.xls
then excel will try to use that file.