Automating Excel
Getting at the Data

Chapter 2 of Automating Excel

The first question that any VBA beginner needs answering is - how do I access the data stored in the spreadsheet. The answer is easy, but it introduces ideas of objects and their properties and methods. This is where the real programming starts.

Read more...
 
Getting started with Excel VBA

Chapter 1 of Automating Excel

When working with an Excel spreadsheet becomes repetitive you need a macro to automate the task - and for this you need VBA. 

Read more...