Introduction
Welcome
()
Using the exercise files
()
1. Getting Started
Understanding what a macro does
()
Reviewing macro examples
()
Understanding security
()
Reviewing the recording method
()
Understanding other techniques for macros
()
2. Running a Macro (Execute, Play Back, Etc.)
Running macros from the View tab
()
Running macros from a keyboard shortcut
()
Running macros from the Quick Access toolbar button
()
Running macros from an object or clip art
()
3. Using Visual Basic for Applications (VBA)
Introducing the VBA environment
()
Viewing the VBA components
()
4. Recording a Macro in Stages
Recording a simple macro
()
Adding functionality to a macro
()
5. Creating Non-Recordable VBA Code
Understanding absolute and relative references
()
Using For and For...Next statements
()
Using Do...While and Do...Until statements
()
Creating interactive macros
()
6. Macro Project: Converting a Mailing List into a Database List
Planning a macro
()
Recording partial code
()
Using loop structures in context
()
Testing a macro in Step mode
()
Pulling the data together
()
Joining two macros
()
Streamlining macros
()
7. The Personal Macro Workbook
Creating a personal macro workbook for macros with wide applicability
()
Closing and updating the personal macro workbook
()
Conclusion
Final thoughts
()
Ex_Files_Ex10_Macros.zip
(3.1 MB)