Returns a FileDialog object that represents a single instance of a file dialog box.

Syntax

expression.FileDialog(Type)

expression A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Type Required MsoFileDialogType The type of dialog to return.

Return Value
FileDialog

Remarks

MsoFileDialogType can be one of these MsoFileDialogType constants.
msoFileDialogFilePicker
msoFileDialogFolderPicker
msoFileDialogOpen
msoFileDialogSaveAs

Example

This example displays the Save As dialog box.

Visual Basic for Applications 
Sub ShowSaveAsDialog() Dim dlgSaveAs As FileDialog Set dlgSaveAs = Application.FileDialog( _ Type:=msoFileDialogSaveAs) dlgSaveAs.Show End Sub

This example displays the Open dialog box and allows a user to select multiple files to open.

Visual Basic for Applications 
Sub ShowFileDialog() Dim dlgOpen As FileDialog Set dlgOpen = Application.FileDialog( _ Type:=msoFileDialogOpen) With dlgOpen .AllowMultiSelect = True .Show End With End Sub

See also: