How to select path with window open up

[ajaygulati]

I want functionality to open up a window and let user browse to the path where he want to send output files. I know how to open file using window pop up using MSA_OPENFILENAME but I need to select the papth instead of opening file.

Do anybody know or did this type of functionality, Please Help!

Ajay

 

[BuGlen]

Hi Ajay,

This article outlines a good way to call the API method to envoke the folder browser.

http://users.skynet.be/am044448/Programmeren/VBA/vba_browse_folder.htm

Hope this helps.

Glen Appleton

VB.Net student.

 

[IvanMoala]

have a look here

http://ozgrid.com/forum/viewthread.php?tid=1832

Ivan F Moala

http://www.xcelfiles.com

 

[VBAjedi]

It may be too simple for what you are after (or the actual filename may get in the way if you only need a folder path), but you can always use:

x = Application.GetSaveAsFilename()

to bring up Excel's standard "Save As" dialogue box. It will return whatever pathname the user specifies to the variable.

VBAjedi

 

[ajaygulati]

Thanks everybody problem solved

 

[VBAjedi]

. . . solved by what/who? We'd like to know what worked, too!

VBAjedi

 

[ajaygulati]

Please see the link.

http://www.mvps.org/access/api/api0002.htm

Thanks to all.