Microsoft Office 2000/Visual Basic Programmer's Guide

HTML and Script

You can also use VBA to work with the HTML and script in an Office document. Through the shared Office component library, Excel, PowerPoint, and Word support two new objects — Scripts and HTMLProject — that expose the properties and methods of the script blocks in a document as well as the properties and methods of the HTML code in the document. For more information about using VBA to work with these objects, see Chapter 6, "Working with Shared Office Components."

You can use VBA in Access to work with the script and HTML code in a data access page. Each data access page has a Document property that returns the DHTML document object. The document object is the gateway to all other objects in a Web page. You can see code examples that use the Document property to return the document object in Chapter 5, "Working with Office Applications." You can see code examples that work with the document object in Chapter 12, "Using Web Technologies."