Workbooks(“SUMIFS with Group Sheet.xlsx”).Close Next, double-click on the CommandButton2 to supply the codes that will automatically close the workbooks. We need to close the VBA editor to return to Excel.
Workbooks.Open “C:\Users\ABIOLA DAVID\3D Objects/bi.xlsx”Įach of the lines of code contains the path located, the names of the Excel workbook and extension which is. Workbooks.Open “C:\Users\ABIOLA DAVID\3D Objects/SUMIFS with Group Sheet.xlsx” To insert Command Buttons: In the Controls group of the Developer tab, click on the Insert drop-down and select Command Button (ActiveX Control) and create two button in the spreadsheet as seen belowĭouble click on the CommandButton1 to open the code window and execute the following lines of code In each of the command buttons, we will write codes that will open and close workbooks respectively So, we are going to open a new workbook where we will write the codes in the VBA Editor In addition, the names of each excel workbook are bi and SUMIFS with Group Sheet.
Note, the two workbooks is located in the 3D Objects on my computer which is important to note and properly referenced when writing the codes. Let’s get startedīelow are the two Excel workbooks we want to write VBA code and assigned to Command Buttons which will automatically open In this tutorial, we will learn how to automatically open and close multiple Excel workbooks with a single click.
0 kommentar(er)
