Set fDialog = Application.FileDialog(msoFileDialogFolderPicker) 'Important we use msoFileDialogFolderPicker instead of (. Locate Microsoft Excel 14.0 Type Library, click the check box next to it, then click OK on the References dialog box. In the VB Editor, go to Tools>References. The dialog below will ask the user to select a folder: Setting up the reference to the Excel library is as simple as this: Open up a new VBA macro in SolidWorks. 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" 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. 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.
0 kommentar(er)
