ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   User Option to save to chosen destination (https://www.excelbanter.com/excel-programming/279421-user-option-save-chosen-destination.html)

patterson_m[_4_]

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/


Ron de Bruin

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/





All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com