Excel is the Office application that is most frequently automated using VBA. In fact, Excel is where it all began. VBA was first implemented in Excel 5 in 1993. This probably happened for the same reason that the mainline accounting functions were the first to be automated using computers in the 1950's. Numbers and computers just go together. So there is a truly rich programming environment with Excel and VBA!
Note - This article is based on Excel 2010.
Every Office application (in fact, every VBA hosting application) saves the VBA program in a slightly different way. The actual VBA program is normally saved as part of the hosting application's documents. In the case of Excel, your VBA program becomes part of your Excel workbook.
To learn how Excel saves a VBA program, let's start with a technique that you will use over and over in writing VBA programs: The Record New Macro tool. But first, we'll have to learn about how Excel saves macros. We get started on that on the next page.