Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 1. Unleash the Power of Excel with VBA

IN THIS CHAPTER

The Power of Excel	7
Barriers to Entry	7
The Macro Recorder Doesn’t Work!	7
Knowing Your Tools—The Developer Ribbon	9
Macro Security	10
Overview of Recording, Storing, and Running a Macro	13
Running a Macro	14
Using New File Types in Excel 2007	17
Understanding the Visual Basic Editor	18
Understanding Shortcomings of the Macro Recorder	20
Next Steps: Learning VBA Is the Solution	28

The Power of Excel

Visual Basic for Applications (VBA) combined with Microsoft Excel is probably the most powerful tool available to you. This tool is sitting on the desktops of 500 million users of Microsoft Office, and most have never figured out how to harness the power of VBA in Excel. Using VBA, you can speed the production ...