Open File Dialog

[etorasso]

I am using Access 2010 (64 bit). I had no problem with the Access 2003 using the GetOpenFileName function with the "comdlg32.d ll" 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

[zmbd]

Please read thru the following insight article, it explains things in great detail.
Select a File or Folder using the FileDialog Object