open windows file dialog
Request a callback

We'll call during UK business hours

0207 987 3777

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Open Windows File dialog box using VBA?

Open Windows File dialog box using VBA?

resolvedResolved · High Priority · Version 2003

Fri 16 Apr 2010, 13:42 Edited on Fri 16 Apr 2010, 13:43 replyReply Delegate Joanne said...

Joanne has attended:
Access VBA course

Open Windows File dialog box using VBA?

Hi I would like to able to open the Windows File Dialog via a command button. Simular as a Browse Files Button. A lot of the samples I have seen open up chosen files but I would like the user to open the C:\Drive and Browse for their File. And also for that path to be pasted into a field? Is this possible?

For upcoming training course dates see: Pricing & availability

Tue 20 Apr 2010, 11:09 replyReply Delegate David said...

RE: Open Windows File dialog box using VBA?

Hi Joanne

I had exactly the same issues a couple of weeks ago. The code I used is:

Private Sub Attach_Click()

Dim varItem As Variant
Dim strPath As String
Dim filePicker As FileDialog

Set filePicker = Application.FileDialog(msoFileDialogFilePicker)

With filePicker

'setup File Dialog'
.AllowMultiSelect = False
.ButtonName = "Select"
.InitialView = msoFileDialogViewList
.Title = "Select File"
.InitialFileName = "G:\z- 2010 General\Information Systems"

'add filter for all files'
With .Filters
.Add "All Files", "*.*"
End With
.FilterIndex = 1

'display file dialog box'

End With

If filePicker.SelectedItems.Count > 0 Then

Dim selectedFile As String
selectedFile = filePicker.SelectedItems(1)

Me.PathToFile = selectedFile

End If

End Sub

Hope this helps!


Tue 20 Apr 2010, 11:31 replyReply Delegate Joanne said...

RE: Open Windows File dialog box using VBA?

Hey David thanks for your help.

Tue 20 Apr 2010, 11:11 replyReply Delegate David said...

RE: Open Windows File dialog box using VBA?

I should also add that the

.InitialFileName = "G:\z- 2010 General\Information Systems"

is where you set your C:\Drive

and the

Me.PathToFile = selectedFile

is where the chosen file location is put into the form/field.



Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips

Training courses
London & UK

Live dates & prices »

On-site training

Get a quote »


Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel training
Course rating
4.7 stars - based on 27809 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom