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