Running MS Explore to find a file.

[Sanibel]

I have an Access VB routine which prompts the user to enter the name of an Excel spreadsheet and import data. It would be much neater if the user could use MS Explore to locate the required file. Does anybody know how I can run MS Explore in VB and get the full path and filename of the selected file.

Thanks

 

[PHV]

You may try the Excel.GetOpenFilename method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya Sanibel . . .

You can make your own stand alone file browser using the GetFileNameFromBrowse API!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[SeeThru]

There was one I pinched a while ago - I think it was from Alan Browns Access Tips.

SeeThru
Synergy Connections Ltd - Uk Telemarketing and Telesales Services and
Synergy Mobile Solutions - UK Mobile phones, land lines and call packages