Your best option would be store the path to the files in a worksheet cell
and reference this cell in your macro. To get the user to choose the path
is a bit tricky as there is not an xL dialog to select paths, only get files
and save file locations.

But you can use the following.....(I have used John's code succesfully)

Jim Rech has a BrowseForFolder routine at:
http://www.oaltd.co.uk/MVP/Default.htm
(look for BrowseForFolder)

John Walkenbach has one at:
http://j-walk.com/ss/excel/tips/tip29.htm
--
Cheers
Nigel



"Nigel" wrote in message
...
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