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

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

Hi Rob,

Thnx a lot. Works great.
--
Thanks a lot,
Hari
India

"Rob van Gelder" wrote in message
...
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