Worksheet

A collection of 9 posts

How to import data In Excel VBA

Below we will look at a program in Excel VBA that imports sheets from other Excel files into one Excel file. Download Book4.xlsx, Book5.xlsx and add them to “C:\test\
21 October 2020

How To Get Path And Fullname In Excel

The Path property in Excel VBA returns the complete, saved path to the workbook (Excel file). The FullName property in Excel VBA returns the complete, saved path, including the name of the workbook.
18 October 2020

How To Use Sales Calculator In Excel

Below we will look at a program in Excel VBA that calculates the total sales of each employee over a period of three years. Situation: The other two sheets have the same setup,
17 October 2020

How To Make Programming Charts In Excel

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. The other program changes some properties
18 March 2020