Save File by Cell Entry and keep macros

[rkjudy]

I am a novice to VB but would like to save a spreadsheet with the contents of a cell as the name. My problem is that I have several macros in the workbook and if I change the name of the file when I save, it won't run the macros when I reopen because the filename has changed. It presents me with an error saying it can't find the macro. Any suggestions anyone?

[mudraker]

If the macro is saved with the workbook then you need to change your macro code so they do not need to to use the workbook name

Instead of using

Please Login or Register  to view this content.

you could use

Please Login or Register  to view this content.

[rkjudy]

Thanks for your help. It worked perfectly, but I have an additional problem along these same lines. I have some macros that call other macros to execute. The Application.Run statement in the running macro references the macro with the original file name. If I save the workbook with a new name, the macro bugs out because the macro with the original file name does not exist in the newly named workbook. Can you help?

[shg]

Why are you using Application.Run?

Post the code?

[rkjudy]

Because I'm a novice, I use the 'Record Macro' most of the time to create my macros and that's the statement it used when I ran another macro while recording. Here are three lines of the macro including the Application.Run statement. Any alternatives?

Please Login or Register  to view this content.

[shg]

Please read the forum rules about code tags, and then edit your post to add them.

Please Login or Register  to view this content.

[rkjudy]

Because I'm a novice, I use the 'Record Macro' most of the time to create my macros and that's the statement it used when I ran another macro while recording. Here are three lines of the macro including the Application.Run statement. Any alternatives?

Please Login or Register  to view this content.

Sorry about the tag.

[rkjudy]

Bump no response

[shg]

Bump no response

Hello? Post #6?

[rkjudy]

Duh, thanks for your help.