Combination of Getopenfilename and Inputbox

[Hari Prasadh]

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

 

[Rob van Gelder]

Chip Pearson has a Browse for Folder example on his website.
http://www.cpearson.com/excel/BrowseFolder.htm

 

[Hari Prasadh]

Hi Rob,

Thnx a lot. Works great.