Run Macro with A Macro

[nassr]

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

 

[shajueasow]

Put the macro you want to run in the personal.xls and run it from there....