method 'run' of object '_application' failed

[Dale Gingerich]

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

 

[Bob Phillips]

The code that does the calling might help to see.

 

[Dale Gingerich]

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

 

[Ashutosh Bhosle]

Hi Dale,
I am facing the same issue so please tell how you resolve this.
Thanks In Advace