GetOpenFilename

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I was wondering if there is a method in Access programming that does the
same as
MyfileName = Application.GetOpenFilename
in Excel programming.

What this does is brings up a standard Windows Open dialog box and returns
the full path of the selected file.

Is there a way of doing this in Access?

Ta.

Neil
 
Requires an API call:
http://www.mvps.org/access/api/api0001.htm

There have been other alternatives suggested over the years, such as the
Common Dialog control (Dev Toolkit--buggy, and versioning problems),
FileDialog object (Office library of 2002 or later: version and runtime
problems, and FileSaveAs fails), Scripting library (library reference
problems), etc, but none that work consistently across all versions and all
scenarios, so we use the API call.
 
Thanks Allen, that's just what I needed. It's a bit longwinded, but does the
job, Thanks a lot.

Neil
 
Back
Top