Call GetFile Name DLL

[George]

I would like a sample VBA code to call a Windows API DLL
that returns a file name to an Access VBA program.
Ideally, the user would click a button on an Access form,
the file open dialog box would appear, the user would
navigate through the directories until they found the
file, they would click OK, and the file name (and path)
would be returned. How can I do this in VBA?

Thank you.

 

[George]

Thank you very much - I modified the code, and now it is
working great!