GetOpenFilename Equivalent

J

John Avitt

I want to use an Open File dialog via code to enable a user to select a file
to import. Once the file is selected, the code will do the rest. Excel has a
GetOpenFilename function. Is there a similar function in Access?

Thank you.

John
 
D

Dirk Goldgar

John Avitt said:
I want to use an Open File dialog via code to enable a user to select
a file to import. Once the file is selected, the code will do the
rest. Excel has a GetOpenFilename function. Is there a similar
function in Access?
Click to expand...

Access 2002 (I think) and later have an Application.FileDialog method,
but I always just call the Windows API directly:

www.mvps.org/access/api/api0001.htm
 
D

Douglas J. Steele

I believe there's one in Access 2002 and newer, but using the API calls is
much better. There are limitations surrounding the built-in dialog.
 
Top