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
|