Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter rows on sheet 2 when a certain option is chosen on sheet 1 | Excel Worksheet Functions | |||
Save as .xla option is not coming when I try to save | Excel Discussion (Misc queries) | |||
Formula to point to another cell if an option is chosen. | Excel Worksheet Functions | |||
Change auto destination in Save As ??? | New Users to Excel | |||
How to set a default paste option of "Match Destination Format" | Excel Discussion (Misc queries) |