Automation

Understanding Macros ■ Common Uses for Macros ■ Planning a Macro ■ Recording a Macro ■ Running the Macro ■ Modifying the Macro ■ Adding Comments ■ Analyzing the Macro Code ■ Cleaning Up the Macro Code ■ Testing the Modified Macro ■ Two Levels of Macro Execution ■ Improving Your Macro ■ Renaming the Macro ■ Other Methods of Running Macros ■ Saving Macros ■ Printing Macros ■ Storing Macros in the Personal Macro Workbook ■ Opening Workbooks Containing Macros ■ The Visual Basic Editor Window ■ Understanding the Project Explorer Window ■ Understanding the Properties Window ■ Understanding the Code Window ■ Other Windows in the Visual Basic Editor Window ■ What's Next...

Are you ready to build intelligence into your Microsoft Excel 2002 spreadsheets? By automating routine tasks, you can make your spreadsheets quicker and more efficient. This first chapter walks you through the process of speeding up spreadsheet tasks with macros. You learn what macros are, how and when to use them, and how to write and modify them. Getting started with macros is easy. Creating them requires nothing more than what you already have—a basic knowledge of Microsoft Excel 2002 menus and spreadsheet concepts. Are you ready to begin? Make sure you are seated at a computer and launch Microsoft Excel 2002.

0 0

Post a comment