macro to save the file as per the path selected

[Ranjit kurian]

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]

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)