The Close and Open Method in Excel VBA can be used to close and open workbooks.

Below we will look at a program in Excel VBA that imports sheets from other Excel files into one Excel file.

Below we will look at a program in Excel VBA that loops through all closed workbooks and worksheets in a directory, and displays all the names.

Below we will look at a program in Excel VBA that loops through all open workbooks and worksheets, and displays all the names.

The Path property in Excel VBA returns the complete, saved path to the workbook (Excel file).

Below we will look at a program in Excel VBA that calculates the total sales of each employee over a period of three years.

Below we will look at two programs in Excel VBA. One program loops through all charts on a sheet and changes each chart to a pie chart.