| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
use current file and folder name
Is it possible to use the value of the file and folder name in a
macro? For example, when you rename/copy a file you want the following code to change: Windows("2007 Accounts.xls").Activate If you copy the file containing the macro it will want to activate the old file and it should activate the new file. Cheers, Harold |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to open most current file in folder | Excel Discussion (Misc queries) | |||
| Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
| Macro syntax to open file in current explorer folder | Excel Discussion (Misc queries) | |||
| Excel should open documents in the folder of the current file | Setting up and Configuration of Excel | |||
| reading from another file and pasting to current file, "combobox" | New Users to Excel | |||
Threaded Mode
