Chapter 5. Explore Data Objects

Chapter at a Glance

image with no caption

In this chapter, you will learn to:

  • Retrieve data from Excel lists and from external data sources.

  • Create and format a table object.

  • Create and format a PivotTable object.

  • Use the macro recorder to learn about Excel objects.

On May 29, 1913, at the staid Théatre des Champs-Elysées in Paris, a scene of utter chaos occurred. It was the premiere performance of Igor Stravinsky’s ballet “The Rite of Spring.” The Stravinsky music and Nijinsky choreography was so outrageously original that the audience couldn’t comprehend it. Today, “The Rite of Spring” is performed without any commotion, but Igor Stravinsky ...

Get Microsoft® Offic Excel® 2007 Visual Basic® for Applications Step by Step 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.