GetOpenFilename

[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

 

[Allen Browne]

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.

 

[Guest]

Thanks Allen, that's just what I needed. It's a bit longwinded, but does the
job, Thanks a lot.

Neil