object representing an instance of the file dialog.
expression.FileDialog(fileDialogType)
expression Required. An expression that returns one of the objects in the Applies To list.
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. |
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.
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