Part II. Excel Objects

These chapters provide a comprehensive guide to using the Excel objects to perform specific tasks. Each chapter in this part combines how-to sections and extensive examples with reference sections for the objects used to perform the tasks. This combined approach helps you navigate the vast set of objects, properties, and methods that Excel provides.

Chapter 7, Controlling Excel

Chapter 8, Opening, Saving, and Sharing Workbooks

Chapter 9, Working with Worksheets and Ranges

Chapter 10, Linking and Embedding

Chapter 11, Printing and Publishing

Chapter 12, Loading and Manipulating Data

Chapter 13, Analyzing Data with Pivot Tables

Chapter 14, Sharing Data Using Lists

Chapter 15, Working with XML

Chapter 16, Charting

Chapter 17, Formatting Charts

Chapter 18, Drawing Graphics

Chapter 19, Adding Menus and Toolbars

Chapter 20, Building Dialog Boxes

Chapter 21, Sending and Receiving Workbooks

Get Programming Excel with VBA and .NET 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.