I am using Access 2010 (64 bit). I had no problem with the Access 2003 using the GetOpenFileName function with the "comdlg32.dll" declaration. With Access 2010 (64 bit) this does not work. I have found the following code on the web to show the Windows open file dialog box. How do I retrieve the path and file name that was selected?
Here is what I found to open the dialog box;
-
Private Sub cmdFileDialog_Click()
-
Dim f As Object
-
Set f = Application.FileDialog(3)
-
f.AllowMultiSelect = True
-
f.Show
-
MsgBox "file choosen = " & f.selecteditems.Count
-
End Sub
Thanks,
ET
