Run a macro within a macro without referencing the file name? Is it possible?

[drew.j.harrison]

So I want to make a macro which runs another macro within that file. Unfortunately when I record my actions I get the following:

Application.Run _
"'TiVCT Purchased Parts Matrix (03-09-11).xls'!Parts_Dropdown_Main"

It works just fine until I change the file name to reflect the current date. Is there anyway I can have it run a macro without having to reference the file name or refer to the current file? Any help is appreciated.

 

[Marc]

How about saving your macro in the Personal workbook, which you can have automatically open each time you open excel so that it will be available.

Then you could tweak your code with:

Application.Run "'PERSONAL.XLS'!Parts_Dropdown_Main"

 

[drew.j.harrison]

Anybody? There has to be some way I can do this short of copying the entire reference macro into the new macro (meaning I would have to update both anytime I decided to tweak them)

 

[drew.j.harrison]

How about saving your macro in the Personal workbook, which you can have automatically open each time you open excel so that it will be available.

Then you could tweak your code with:

Application.Run "'PERSONAL.XLS'!Parts_Dropdown_Main"

If I am reading this right you are suggesting I separate the macros from the file and house them in a separate file. That could work fine if I was the only one using this sheet but unfortunately I need to be able to to send it to others to use with working macros and I would prefer not to have to send them a separate macro file with it. Do I understand you correctly or am I missing something?

 

[jmthompson]

have you tried

 Call Parts_Dropdown_Main

 

[drew.j.harrison]

have you tried

 Call Parts_Dropdown_Main

Worked Perfect! Didn't know about the call command. Thanks!