![]() |
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/ |
All times are GMT +1. The time now is 12:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com