Access VBA Tip: Select File or Folder using FileDialog

Sign in to queue


Do you ever wonder how to prompt for a file or folder from within an Access database?
I'm going to show you how to select a file or folder using the FileDialog object that comes with Microsoft Office. This is available from Microsoft Access of course.  I also have some VBA code here you can download to help you do this.

~~ Links ~~

Select a File or Folder using the FileDialog Object

Download: FileDialog.Zip

Bytes free forum to get Access help

Access and Excel Consulting

Adrian, AKA NeoPa


Access, Office, VBA, File



Download this episode

The Discussion

  • User profile image

    Great video, Adrian. Lots of applications (Access, Word, Excel, or PowerPoint) need to select files and folders. You explain things thoroughly -- from referencing the Microsoft Office Object Library to specifying information for the the file and folder dialog box and using the return value in VBA ... and also setting Breakpoints and tracing through the code.  

    Thank you, this tutorial will be a good link to pass on ~


  • User profile image

    Thanks Crystal.


    Your help and involvement with the presenting of the information was invaluable :)



  • User profile image

    @AdrianBellMVP: you're welcome and thanks, Ade -- it was fun, and I learned a few things too!

Add Your 2 Cents