Expand Minimize

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

Parameters

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 
        .Show 
 
        ' Display paths of each file selected 
        For lngCount = 1 To .SelectedItems.Count 
            MsgBox .SelectedItems(lngCount) 
        Next lngCount 
 
    End With 
 
End Sub
Show:
© 2014 Microsoft