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.
Name | Required/Optional | Data type | Description |
---|---|---|---|
fileDialogType | Required | MsoFileDialogType | The type of file dialog. |
MsoFileDialogType can be one of these 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. After 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
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.