method 'run' of object '_application' failed
thank you for the response, and i have also figured out why the application
failed, simply put, i was calling macros, within macros.....which allowed
them to function normally until the file name was changed......then the
application failed error....
thanks for your response...
dale
"Bob Phillips" wrote:
The code that does the calling might help to see.
--
HTH
Bob
"Dale Gingerich" wrote in message
...
i receive this message after attempting to "save as" to a new workbook
name,
it appears that some of the macros are referenced by the original workbook
name and after renaming, the macros no longer function. is there a fix or
workaround or something that i can run/do to fix this problem?
i have templated up a little workbook that will be used on a monthly basis
and saved accordingly.....each month, etc.....so the name of the file will
change......
what have i done or what have i missed..
thanks in advance,
dale
.
|