Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for changing path in macro
Hi,
can a macro be written to change a path set a macro to another location of your choice? I.E. my current macro saves to "s:\Invoicing\Sales 05 06" but as we have remote users, this path changes because they need these files to save locally too. i was wondering if i included a button, they could start the command, open a dialog box and select their new location to save. This would then be the set location on the macro until it is changed. Is this possible? Thanks, Nigel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Path - Macro | Excel Worksheet Functions | |||
How to remove path from macro reference | Excel Discussion (Misc queries) | |||
Setting a defaut path in a Macro | Excel Programming | |||
File Path Macro | Excel Programming | |||
How to lock the path to a macro | Excel Programming |