VBA Browser Call

C

C Brandt

Up to present, I have been restricting my users to keeping their flat files
in a specific directory, then hardcoded that path into the routine.
It has now gotten to the point where this is clubersome for all involved.

Is there a simple call that will bring up the standard browser in order to
get the path and filename of a desired resource.

Any help would be appriciated,
Craig
 
J

Jim Thomlinson

Here is the simplest way to get a file name and path. Note It does not open
the file...

Dim strFileName As String

strFileName = Application.GetOpenFilename
MsgBox strFileName
 
Top