Office® XP Development with VBA

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 ...