Function to open windows explorer

[Powderfinger]

I would like to write a VBA function that open windows explorer (or some
browse utility like it) default to some directory, display the files in the
directory, and returns the directory and filename that the user has
selected.

Jack

 

[Allen Browne]

It's all here for you:
Call Windows File Open/Save Dialog box
at:
http://www.mvps.org/access/api/api0001.htm

 

[Ron2006]

You can also do a

docmd.followhyperlink and supply the directory name.