Chapter 36. Automating Repetitive Functions Using VBA Macros
In this chapter
Checking Security Settings Before Using Macros 970
Case Study: Macro for Formatting for a Mail Merge 972
Everyday-Use Macro Example: Formatting an Invoice Register 979
Understanding VBA Code—An Analogy 982
Using Simple Variables and Object Variables 986
Customizing the Everyday-Use Macro Example: GetOpenFileName and GetSaveAsFileName 990
From-Scratch Macro Example: Loops, Flow Control, and Referring to Ranges 991
Combination Macro Example: Creating a Report for Each Customer 998
Every copy of Excel shipped since 1995 has included the powerful Visual Basic for Applications (VBA) lurking behind the grid. ...
Get Special Edition Using Microsoft® Office Excel® 2007 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
