Prev: Joel - Data Consolidate Limitation
Next: Macro Message Box
From: Dale Gingerich on 4 Apr 2010 04:52
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
From: Bob Phillips on 4 Apr 2010 05:34
The code that does the calling might help to see.

--

HTH

Bob

"Dale Gingerich" <DaleGingerich(a)discussions.microsoft.com> wrote in message
news:6F564011-100A-4B51-BE5D-AA56B31955DB(a)microsoft.com...
>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


From: Dale Gingerich on 5 Apr 2010 14:49
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" <DaleGingerich(a)discussions.microsoft.com> wrote in message
> news:6F564011-100A-4B51-BE5D-AA56B31955DB(a)microsoft.com...
> >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
>
>
> .
>
 | 
Pages: 1
Prev: Joel - Data Consolidate Limitation
Next: Macro Message Box