Please follow below for the code Sub SaveFile()įileName = Application.GetSaveAsFilename('MyFileName.xls', _ : This is used in Mac system to change the name of the button. If you don't rename the file while saving it, your file will be saved with this name. Syntax of the method is:Īpplication.GetSaveAsFilename(,) To open a Save As dialog box we will use the GetSaveAsFilename method of the Application object. This will enable the multiple selection of the file. Note that here we have set the multiselect variable to True. Sub OpenMultipleFiles()įileName = Application.GetOpenFilename('Excel-files,*.xlsx', _ġ, 'Select One Or More Files To Open',, True) This segment of code will open the file open dialog box but you will be able to select more than one file at one time.

VBA Code To Open One or More File at a Time

If you don't select a file, the sub will exit without running the Workbook.Open code. If you select a file then the Worbook.Open code will run and the file will be opened. The title of the dialog box will be 'Select One File To Open' as we defined in the code. When you run this segment of code, the GetOpenFilename method for the Application object will open an Open File Dialog box. If TypeName(FileName) = 'Boolean' Then Exit Sub VBA Code To Open One File at a Time Option ExplicitįileName = Application.GetOpenFilename('Excel-files,*.xls', _ If you set it false, you can only select only one file.Įnough of the theory. If you set it True or 1, you will be able to select more than one file. : It is the number of file filters you want to use. then only excel files will be shown from the folder in the file open dialog box. If you write 'Excel-Files, *.xlsx, *.xls, *.xlsm' etc. : You can define to show only one kind of file in the select folder. The syntax of the GetOpenFilename method is:Īpplication.GetOpenFilename(,) In this code, we will use GetOpenFilename method of Application. Workbook attached to this article contains three macros VBA Code to Open File Using Open File Dialog I have attached a workbook that you can download. In this article, we cover the code used for displaying workbook open dialog box and save as dialog box. But most of the time you will want the end user to select a file using GUI or say File Open or Save As Dialog box that lets the user choose the location of the file visually and easily. But that requires hard-coding of the path of the file. We simply use the Open and SaveAs method of Workbook object. We already know how to open or save an Excel file in VBA.

Vba if file open