macro to save the file as per the path selected

Ranjit kurian · Sep 17, 2008

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 · Sep 17, 2008

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/tip/selecting_a_directory/

If you and all your users are running xl2002+, take a look at VBA's help for:
application.filedialog(msoFileDialogFolderPicker)

save worksheet as per the active cell	2	May 13, 2008
Save All Worksheets as CSV	7	Nov 9, 2010
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename	4	Mar 23, 2019
Macro Problem	4	Jun 15, 2008
Save-as without stating path	7	Oct 12, 2009
save and exit macro	8	Jun 24, 2012
Save ActiveWorkbook dilemma	3	Jun 27, 2011
Saving One Sheet as One Workbook	3	Jul 24, 2007

Ask a Question