Chapter Summary

When a document is created or an existing document opened, you can insert or manipulate content such as text, tables, shapes, and other objects, such as charts. How to manipulate content varies between Word, Excel, and PowerPoint, and this chapter discussed the similarities and differences between the three applications. To manipulate content in Word, the main object you'll use is the Range object, which allows you to manipulate text. In Excel, you'll use the main object, also named Range, to manipulate content in a range of cells. In PowerPoint, you'll use two main objects: the Shape object and the TextRange object. You'll employ these objects the most when using Visual Basic code to insert and edit content in documents. Chapter 8 describes how to use the main object in Access, the RecordSet object, to retrieve data content in an Access database.