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