Windows Explorer

[Samuel]

Hello.

Is it possible to use automation with windows explorer?

I want to open a folder to allow the user to select a file.

Any ideas?
Sam.

 

[Allen Browne]

To open the Windows File Open dialog for the user to select a file, and
receive the file name in code, see:
Call Windows File Open/Save Dialog box
at:
http://www.mvps.org/access/api/api0001.htm

If you just want to open the Windows Explorer without needing to know what
was selected, use:
Application.FollowHyperlink("C:\MyFolder")

 

[Samuel]

I was hoping to get the name of the file selected in
Explorer.

I think i saw a thread explaining how to use a switch in
the shell call to explorer.exe but cant find it again now?

Thank you for the help.
Sam