The FileDialog Object
The FileDialog object provides functionality similar to that of the standard Open and Save dialog boxes in each Office application. There are several types of FileDialog objects, but a given Office application can have only one instance of this object open at a time. This means that if you have created a FileDialog object of one type and now need another type, you must destroy the first object and then create a new one. To create a FileDialog object, use the Application.FileDialog method. The syntax is
Dim fd As FileDialog
Set fd = Application.FileDialog(type)
Type is a constant specifying the type of FileDialog to create. The constants that are used for this argument and descriptions of the corresponding dialog boxes ...
Get Office® XP Development with VBA now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.