ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   method 'run' of object '_application' failed (https://www.excelbanter.com/excel-programming/441312-method-run-object-_application-failed.html)

Dale Gingerich[_2_]

method 'run' of object '_application' failed
 
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[_4_]

method 'run' of object '_application' failed
 
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




Dale Gingerich[_2_]

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



.



All times are GMT +1. The time now is 01:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com