This documentation is archived and is not being maintained.

Application.FileDialog Property

Office 2007
Returns a FileDialog object representing an instance of the file dialog.



expression   A variable that represents an Application object.


NameRequired/OptionalData TypeDescription
fileDialogTypeRequiredMsoFileDialogTypeThe type of file dialog.


MsoFileDialogType can be one of these MsoFileDialogType constants.
msoFileDialogFilePicker. Allows user to select a file.
msoFileDialogFolderPicker. Allows user to select a folder.
msoFileDialogOpen. Allows user to open a file.
msoFileDialogSaveAs. Allows user to save a file.


In this example, Microsoft Excel opens the file dialog allowing the user to select one or more files. Once these files are selected, Excel displays the path for each file in a separate message.

Visual Basic for Applications
Sub UseFileDialogOpen()

    Dim lngCount As Long

    ' Open the file dialog
    With Application.FileDialog(msoFileDialogOpen)
        .AllowMultiSelect = True

        ' Display paths of each file selected
        For lngCount = 1 To .SelectedItems.Count
            MsgBox .SelectedItems(lngCount)
        Next lngCount

    End With

End Sub