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 blog)
- Using FileDialogs in VBA
- FileDialogs for Selecting Multiple Files
Posted by Andy Brown on 13 January 2012 | 1 comment
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
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.
This blog has 1 comment
A full-blown discussion forum is being built for this site, which will allow you once more to add comments and discussion threads.