Mastering VBA for Microsoft Office 2007, 2nd Edition

Chapter 1

Recording and Running Macros in the Microsoft Office Applications

In this chapter, you’ll learn the easiest way to get started with Visual Basic for Applications (VBA): recording simple macros using the built-in Macro Recorder in the Microsoft Office applications and then running macros to repeat the actions they contain.

By recording macros, you can automate straightforward but tediously repetitive tasks and speed up your regular work. You can also use the Macro Recorder to create VBA code that performs the actions you need, and then edit the code to customize it — adding flexibility and power. In fact, VBA is a real powerhouse if you know how to use it. This book shows you how to tap into that power.

In this chapter you will learn ...