Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

HOW TO CHOOSE FILES AND FOLDERS IN VBA

Part one of a three-part series of blogs

To make it easier for users of your VBA systems to choose files, you can show FileDialogs on screen. This blog explains what these are, and how to customise them.

  1. Overivew of File and Folder Dialog Boxes (this article)
  2. Using FileDialogs in VBA
  3. FileDialogs for Selecting Multiple Files

This blog is part of a complete Excel VBA tutorial.  Have a look also at our VBA training courses.

Posted by Andy Brown on 13 January 2012 | 1 comment

Using File and Folder Dialog Boxes in VBA

Often in VBA you need to ask someone to choose a file or folder, using a dialog box like this one:

Dialog box for choosing file

Many parts of this dialog box have been customised

This blog explains how to display a dialog box like this, how to customise it and - most importantly - how to get at the file or files selected.

 

HOW TO CHOOSE FILES AND FOLDERS IN VBA

Part one of a three-part series of blogs

To make it easier for users of your VBA systems to choose files, you can show FileDialogs on screen. This blog explains what these are, and how to customise them.

  1. Overivew of File and Folder Dialog Boxes (this article)
  2. Using FileDialogs in VBA
  3. FileDialogs for Selecting Multiple Files

This blog is part of a complete Excel VBA tutorial.  Have a look also at our VBA training courses.

Comments on this blog

This blog has one comment:

Comment added by bob alou on 24 October 2012 at 17:50 GMT
The article was very easy to follow and expand on. I was trying to add a button to an Excel spreadsheet to return the path of a file from which I could then link to from my spreadsheet to reduce redundant data entry.

Your blog was a big help over here on the other side of the pond in Texas.

Thank you.

All content copyright Wise Owl Business Solutions Ltd 2014. All rights reserved.