Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Method 'Display Alerts' of object '_Application' failed | Excel Programming | |||
Method 'COMAddIns' of object '_Application' failed | Excel Programming | |||
1004 method 'COMAddIns' of object '_Application' failed | Excel Programming | |||
Method 'ActivePrinter' of object '_Application' failed | Excel Programming | |||
Method 'Run' of object '_Global' failed when changing OS and Office versions | Excel Programming |