Working with Scripts
You can use the Scripts collection and the Script object to programmatically access script, or insert script into a cell or range in a Microsoft® Excel worksheet, a Microsoft® PowerPoint® slide, or a Microsoft® Word document or Word Selection object. In addition, if you use a Microsoft® Office application to open an HTML page, any script contained in that page will be available through the Scripts collection.
Every Script object that is inserted in an Office document includes a Shape object of the type msoScriptAnchor. In Excel and PowerPoint, these shapes are added to the Worksheet or Slide object's Shapes collection. In Word, these shapes are added to a document's InLineShapes collection.
If you want to write script in a document you create in an Office application, use the Microsoft Script Editor. On the other hand, if you want to add script to an Office document programmatically, from an add-in for example, use the objects, properties, and methods of the script object model discussed here.
In This Section
- Understanding Script Object Properties
- Learn how to access Script objects and add them to documents.
- Adding and Removing Script from a Document
- Add script to and remove script from a document by using the Scripts collection's Add and Delete methods.
Related Sections
- Working with Shared Office Components
- Search for files, use the Office Assistant, manipulate command bars, read and write document properties, read and write script, and hook add-ins to your Microsoft® Office application using a set of shared objects available in all Office applications.
- Referencing Shared Office Components
- Return a reference to a shared component object by using the appropriate properties.
- Working with the FileSearch Object
- Programmatically access the functionality of the Office File Open dialog box.
- Working with the Office Assistant
- Use the objects, methods, and properties of the Office Assistant object to programmatically control the Office Assistant.
- Working with Command Bars
- Write code to manipulate command bars that can be used in any Microsoft® Office application or custom application you develop.
- Working with Document Properties
- Use document properties to create, maintain, and track information about a Microsoft® Office document.