Set fDialog = Application.FileDialog(msoFileDialogFolderPicker) 'Important we use msoFileDialogFolderPicker instead of (. The dialog below will ask the user to select a folder: However only a single folder can be select within a single dialog window. Selecting a folder is more simple than selecting files. Notice that you need to set AllowMultiSelect to True. Quite common is a scenario when you are asking the user to select one or more files. Set fDialog = Application.FileDialog(msoFileDialogFilePicker)į 'Excel files', '*.xlsx' FileDialog(msoFileDialogFolderPicker) see also msoFileDialogFolderPicker, msoFileDialogOpen, and msoFileDialogSaveAs uses Excels default opening path but. The code below does just that:ĭim fDialog As FileDialog, result As Integer The most common select file scenario is asking the user to select a single file. To open a workbook using VBA, you need to use the Workbook.Open method and specify the path of the file (make sure to specify the full path to the.

The msoFileDialogFilePicker dialog type allows you to select one or more files. Can be one of the following:Ĭollection of type FileDialogSelectedItems with all selected items Set a file filter to filter file types user can select Text displayed on the action button of a file dialog box Properties and functions FileDialog properties PropertyĪllow to select more than one file or folder The Application.FileDialog has the following syntax:Īpplication.FileDialog( fileDialogType as MsoFileDialogType )Īn enumeration defining the type of file dialog to open. Before we start let’s understand the Application.FileDialog function.

Visual basic for excel open file dialog