View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dale Gingerich[_2_] Dale Gingerich[_2_] is offline
external usenet poster
 
Posts: 2
Default 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



.