By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,041 Members | 1,793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,041 IT Pros & Developers. It's quick & easy.

Open File Dialog

P: 12
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;
Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdFileDialog_Click()
  2. Dim f    As Object
  3. Set f = Application.FileDialog(3)
  4. f.AllowMultiSelect = True
  5. f.Show
  6. MsgBox "file choosen = " & f.selecteditems.Count
  7. End Sub

Nov 25 '13 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397
Please read thru the following insight article, it explains things in great detail.
Select a File or Folder using the FileDialog Object
Nov 25 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.