Page 16 - Excel Progamming Weekend Crash Course

540629 FM.qxd 9/2/03 4:10 PM Page xiii

Contents

Preface .........................................................................................................v
Acknowledgments ......................................................................................xiii
FRIDAY.......................................................................................................2
PART I–Friday Evening ...........................................................................4
SESSION 1–Microsoft Excel Programming — Why and How ................................5
Advantages of Programming ....................................................................5
Saving Time .......................................................................................6
Reducing Errors ...................................................................................6
Enforcing Standards .............................................................................6
Integrating with Other Applications .........................................................6
Programming Fundamentals ....................................................................6
Creating Instructions ............................................................................7
Handling Data ....................................................................................7
The VBA Language .................................................................................7
The Excel Object Model ............................................................................8
Objects ..............................................................................................8
Components and Automation ..................................................................9
Macros and Programming .......................................................................10
Designing Your Custom Application .........................................................10
Your First Excel Program ........................................................................11
Creating and Naming the Program ..........................................................11
Writing the Code ................................................................................12
Running the Program ............................................................................14
SESSION 2–The VBA Code Editor ..................................................................17
Code and Project Organization ................................................................17
The Project Explorer ............................................................................19
Importing and Exporting Modules ...........................................................19
Editing Tools .......................................................................................20
The Property Window ............................................................................22
The VBA Editor Menus ...........................................................................23