Microsoft KB Archive/113891

= Using AppleScript with Excel for Mac =

Article ID: 113891

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Excel 2004 for Mac
 * Microsoft Excel X for Mac
 * Microsoft Excel 2001 for Mac
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q113891



SUMMARY
Microsoft Excel for Mac and later versions support AppleScript in the scriptable capacity. With this feature, you can control Excel for Mac from other programs or scripts.



MORE INFORMATION
AppleScript is an English-like language that is used to write script files that can control the actions of the computer and the programs that run on it. To use the program-specific capabilities of Excel for Mac with AppleScript, open and examine the AppleScript dictionary that is supplied with Excel for Mac.

To use the Script Editor open the dictionary in Excel for Mac, follow these steps:  Start the Script Editor. To do this, follow these steps:  Open your hard disk. Open the Applications folder. Open the AppleScript folder. For the Apple OS versions earlier than OSX, open the Apple Extras folder, and then open the AppleScript folder. Double-click Script Editor.  On the File Menu, click Open Dictionary.</li> In the Open Dictionary dialog box, select Microsoft Excel (Application) in the Name list, and then click Open.</li></ol>

In the window that appears, you can select an object or a class to view its description. You can also click the bold suite names to view an whole suite at one time. You can use the descriptions in this window to create scripts in the Script Editor to control Excel for Mac.

The versions of Excel for Mac listed at the beginning of this article support a very large number of events. For a complete list, follow the instructions in this article to open Excel for Mac in the AppleScript Script Editor.

<div class="references_section">