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.

Syntax

expression.FileDialog(fileDialogType)

expression   A variable that represents an Application object.

Parameters

NameRequired/OptionalData TypeDescription
fileDialogTypeRequiredMsoFileDialogTypeThe type of file dialog.

Remarks

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.

Example

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

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

    End With

End Sub



Show: