Part II: Object Models

Chapter List

Chapter 12: The Excel Object Model

Chapter 13: The Excel Object ModelMain Objects

Chapter 14: Using Excel to Interact with Other Office Programs

In this part, you will learn all about the Excel object model and how to use it within your code. The Excel object model is at the heart of VBA programming for Excel. It empowers you to do anything in code that you can do from the Excel menu andas you will find in the practical examples later on in the bookplenty more that cannot be done from the Excel menu!

You will also learn how to use Excel object models to interact with other Microsoft applications. For example, you will learn how to send custom e- mails through Microsoft Outlook and create a custom Word document.