VBA Browser Call

  • Thread starter Thread starter C Brandt
  • Start date Start date
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
 
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
 
Back
Top