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
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

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....
 

Forum statistics

Threads
1,141,011
Messages
5,703,725
Members
421,311
Latest member
tanujath

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top