Run Macro with A Macro

nassr

New Member
Joined
Sep 8, 2006
Messages
11
I am attempting to run a macro prior to perfroming other activities. I attempt to use:

Application.Run _"FileName.MacroName"

But I have a file with a constantly changing name, so I do not want to lock in a name. Here is what I currently have:

Application.Run _
"'FY07 Spend Plan Temp Rev 33 TEST.xls'!CopyFormulas.CopyFormulas"

The xls file name will always be changing. Is there anyway to account for this? Thanks
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
Put the macro you want to run in the personal.xls and run it from there....
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,444
Members
410,610
Latest member
renatha prado
Top