Browse Folders

[Rob.Mills]

I have created a procedure to transfer multiple tables to excel sheets. What I would like is for them all to go into the same folder. I've created a form that will allow people to type in the path of the folder.

What I would like is to add a button on this form that will open the browser window so that people can scroll through to find the folder they want and have it automatically place that path in the textbox. Anyone know how to do this?

 

[Travis]

You could use the Common Dialog Control, Common Dialog Control API, or the SHBrowseForFolder API.

The SHBrowseForFolder API sets up a Browser that shows only Drives and Folders and sounds more like what you want.

Visit this web site for an Example

vbnet

 

[ghudson]

API: BrowseFolder Dialog

 

[Haitham]

Brows Folder

It's I Guess Easy,

Dim BrowsFolder
BrowsFolder = Shell("C:\Program Files\Internet Explorer\IEXPLORE.EXE " & "C:\Any Folder", vbNormalFocus)
End Sub

Don't 4get The Space After (Iexplore.exe).

Good Luck