Using a browser dialog to select a file

[LuigiX]

Hi

I've got an open excel spreadsheet with a user form. The user form has a button on it that will open a browser dialog which allows me to select an access database. Once I have selected the database the full file path and name of the selected database must populate a text box on the user form then the dialog closes.

It is the code that opens the dialog on clicking the button and allows me to select the file from a browser, then populates the text field with the path and file name that I'm after.

Any help is apreciated. I'm sure this has been done before but all I can find is code to open a selected file. I don't want to open it, just transfer the file name to a text box.

Thanks for your help

Cheers

Luigi

 

[tkpstock]

FileDialog

Do a search under FileDialog - you should get all you need.

Microsoft info here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_filedlgobjs.asp

 

[LuigiX]

Hi

This appears to be all written for XP. Can you suggest anything for 2000?

Cheers

Luigi

 

[RoyVidar]

If it's for Excel, you could consider the Excel forum of the site.

Anyway, for Excel, have a look at the .GetOpenFileName or .GetSaveAsFilename methods of the Excel application object.

For Access, have a look at
http://www.mvps.org/access/api/api0001.htm