Chapter 41 -- Working with Office Application Objects

Chapter 41

As you learned in the previous chapters, Microsoft Office macros can readily access the commands of Office applications by using programmable objects. You manipulate these objects in macros by setting properties, using methods, and building statements. In this chapter, you'll learn how to use the objects of several different applications from a single macro. You'll learn how to use functions in Microsoft Excel, send electronic mail via Microsoft Outlook, run a presentation in Microsoft PowerPoint, and browse the Web using Microsoft Internet Explorer. When you're finished, you can continue exploring Office macros on your own by using a special tool called the Visual Basic Object Browser.