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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

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,176,367
Messages
5,902,732
Members
434,990
Latest member
Peter Jeffrey Gale

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