Soft-coding document name?
Does this mean that the line of code is in the workbook named:
"May 06 Outlook - prelim.xls"
If yes, you can use:
Thisworkbook.activate
Rick Charnes wrote:
We have the following line in an Excel macro
Windows("May 06 Outlook - prelim.xls").Activate
I believe the macro is attached to the document "May 06 Outlook -
prelim.xls". Next month this doc will be modified and renamed to "June
07 - prelim.xls". Is there a way to soft-code the document name (into a
variable?) here so that every time this macro is run the variable
expands to the doc name?
--
Dave Peterson
|