| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to save the file as per the path selected
Jim Rech has a BrowseForFolder routine at:
http://www.oaltd.co.uk/MVP/Default.htm (look for BrowseForFolder) John Walkenbach has one at: http://spreadsheetpage.com/index.php...g_a_directory/ If you and all your users are running xl2002+, take a look at VBA's help for: application.filedialog(msoFileDialogFolderPicker) Ranjit kurian wrote: I need macro to save my active workbook, but before saving the activeworkbook it should ask me where and to which folderit need to be saved. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a path to save a file | Excel Programming | |||
| Want to Set the File Save As path | Excel Programming | |||
| Macro to Sort automatically when file/save is selected | Excel Discussion (Misc queries) | |||
| file save as (path and custom name) | Excel Programming | |||
| get path - save new file - same sub-directory as existing file | Excel Programming | |||
Linear Mode
