Application.FileDialog Property (Excel)

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


expression. FileDialog( _fileDialogType_ )

expression A variable that represents an [Application](./Excel.Application(Graph property).md) object.


Name Required/Optional Data Type Description
fileDialogType Required MsoFileDialogType The 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.

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

See also

Application Object