User Option to save to chosen destination
 

Is there a way to enable the user to save, and then be given the ability
to choose the destination drive/folder etc?

All the 'save' spreadsheet tips seem to save to a predetermined
filepath.

My users are on a network and have their own drive and folders and I
want to give the user the choice where to save.

Thanks

Mark



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

User Option to save to chosen destination
 

See the VBA help for Application.GetSaveAsFilename

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"patterson_m" wrote in message ...
Is there a way to enable the user to save, and then be given the ability
to choose the destination drive/folder etc?

All the 'save' spreadsheet tips seem to save to a predetermined
filepath.

My users are on a network and have their own drive and folders and I
want to give the user the choice where to save.

Thanks

Mark



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/