Chip Pearson has a Browse for Folder example on his website.
http://www.cpearson.com/excel/BrowseFolder.htm
--
Rob van Gelder -
http://www.vangelder.co.nz/excel
"Hari Prasadh" wrote in message
...
Hi,
I want user to be prompted for the location of FOLDER in to which a
particular file will be saved.
Basically a dialog box like inputbox but having the browse button as in
Getopenfilename.
Is there a facility for the same in Excel?
Please guide me
--
Thanks a lot,
Hari
India