Page 40 - Excel Progamming Weekend Crash Course

d540629 ch01.qxd 9/2/03 9:27 AM Page 15

Session 1 — Microsoft Excel Programming — Why and How 15

Even though this is a simple program, it illustrates some of the advantages of Excel pro-
gramming as related to accuracy and consistency. Specifically, it ensures that:
Data is entered into the proper worksheet cells.
The correct formula is used.
The workbook is saved under the correct name.
With the fundamentals under your belt, you are ready to move on to the next session
and start learning the details of Excel programming.

Figure 1-5 The worksheet after the program runs

REVIEW

In this session you learned some of the fundamentals and background of Excel programming,
including:
There are several advantages of programming Excel.
You use the VBA language to write Excel programs.
Excels makes its functionality available to VBA as components.
The components that Excel exposes are collectively called the Excel object model.
Excel macros are a simple form of programming.
Planning ahead is important when designing a program.