Wise Owl's Blog
Making Sense of Software
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.
- Overivew of File and Folder Dialog Boxes (this article)
- Using FileDialogs in VBA
- FileDialogs for Selecting Multiple Files
This blog is part of a complete Excel VBA tutorial.
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:
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.
- Overivew of File and Folder Dialog Boxes (this article)
- Using FileDialogs in VBA
- FileDialogs for Selecting Multiple Files
This blog is part of a complete Excel VBA tutorial.
Comments on this blog
This blog currently has no comments.