| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Soft-coding document name?
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difficult for me, probably basic to you | Excel Worksheet Functions | |||
| Word found no merge fields in your main document. | Excel Discussion (Misc queries) | |||
| Help: Can't display contents of Adobe Acrobat Document in Sheet | Excel Discussion (Misc queries) | |||
| How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
| Hyperlink to a word document | Excel Discussion (Misc queries) | |||
Threaded Mode
