Liste der von EXCEL 5.0 unterstützten AppleScript-Befehle

Ich arbeite mit AppleScript und möchte Microsoft EXCEL 5.0 für den Apple Macintosh über AppleEvents ansteuern.
Welche Script-Befehle unterstützt EXCEL 5.0?

Die von einem Programm unterstützten Script-Befehle können direkt vom Script-Editor ausgelesen werden. Dazu gibt es im Menü ABLAGE den Befehl "Verzeichnis öffnen...". Dort kann die gewünschte Applikation direkt angewählt werden und die unterstützten Events und Objekte werden angezeigt.
EXCEL 5.0 unterstützt folgende Script-Befehle und Objekte:

Erforderliche Folge - Events that every application should support:

open Open the specified object(s)
print Print the specified object(s)
quit Quit application
run Sent to an application when it is double-clicked

Miscellaneous Standards - Miscellaneous standard events and classes:

Activate Activate the object
ActivateMicrosoftApp Activate some Microsoft application
ActivateNext Activate the window following the given window
ActivatePrevious Activate the window preceding the given window
AddCustomList create a new custom list
AddFields Add fields to a pivot table
AddItem Add a new item to a listbox
AddMenu Creates a new submenu
AddVertex Append a new vertex to the end of the given polygon
Arrange Arrange all windows or all windows belonging to a document
AutoFormat apply an auto format
Cancel tell some object to cancel itself
ChangeFileAccess Change the access permissions for the workbook
ChangeLink Change a link from one document to another
ChangeScenario Change the changing cells and values of a scenario
Clear Clear some object
ClearArrows Clear arrows from a worksheet
ClearContents Clear the contents of some object
ClearFormats Clear formatting of some object
Close close an object
ConvertFormula convert formula between different reference styles
CopyFace Copy the face of a toolbar button
CopyObject copy an object
CopyPicture Copy the object
Create Creates a new element.
CreatePublisher create a new publisher for the given range
CreateSummary create a summary report for the scenarios on a worksheet
CustomListContents return the contents of the given custom list
CustomListNumber the number of the given custom list
cut Cut the object
DDE perform some DDE command
Delete delete an object
DeleteCustomList delete a custom list
DeleteNumberFormat delete an number format from a workbook
DoScript run a macro
DoubleClick Equivalent to double clicking the active cellDuplicate clone the given object
Edit Invoke the toolbar button editor
EditionOptions Set options to publishers and subscribers in a workbook
Evaluate This event passes one or a list of Excel functionsFillAcross Copy a range of cells to all given sheets
FindFile Bring up Excel's Find File dialog
FunctionWizard Perform a Function Wizard on a cell
Get Get the data for an object. Handles extra parametersGetOpenFilename Displays the Excel Open dialog
GetSaveAsFilename Displays the Excel Save As dialog
Goto Selects the given range of VBA procedure
Group Group objects or cells together
Help run the Help command for some topic
Hide hide a dialog that was run from a dialog sheet
Import load a sound resource from a file
InputBox Display the Excel input box
Insert Add text to an object
InsertFile Insert a text file into a module
LinkCombo Create a combo item out of a listbox and an edit item
LinkInfo Returns information on links
LinkSources Return links of the given book
LineScroll provide a way to scroll documents
ListNames lists all non-hidden names defined on the worksheet
Move Move the object
Merge merge objects together, like styles
OnKey Runs a specified macro when a key or key
combination is pressed
OnRepeat Runs a specified macro when Edit/Repeat is chosen
OnTime Runs a specified macro at a particular
OnUndo Runs a specified macro when Edit/Undo is chosen
Open Open an object
OpenLinks Open the supporting documents of links
OpenText Open an object
PageScroll provide a way to scroll documents
paste paste to an object
PasteFace Paste the face of a toolbar button
PasteSpecial paste to an object
PivotTableWizard Perform a Pivot Table Wizard
Play play a sound or movie or something
Print Print object(s)
PrintPreview Preview an object
Protect turn protection on for sheets and documents
Recalculate Forces a recalculation of all sheets. This is useful
if the recalculation mode of the application has been
set to manual.
Record record a sound
RecordMacro Record text into a VBA or XLM macro
RefreshTable Refreshes pivot table with lastest data from source
RegisterXLL Load an XLL code resource and register it
RemoveAllItems Remove all items from a listbox
RemoveItems Remove some items from a listbox
RepeatCommand Repeats the last user interface command
Reset Restores an object to it's default state
ResetTipWizard Resets the Tip Wizard so that all tips will be shown
Reshape Reshape a drawing by inserting, deleting or moving
a vertex
RunAutoMacros Run some auto macros on a given workbook
Save Save an object
SaveCopy Save a copy of an object
Select Select the object
ScrollWorkbookTabs Scroll the workbook tabs of the given window
SetInfoDisplay Set the information to display in the info window
SetLinkOnData Set a macro to run whenever a link is updated
Show make something visible
ShowAllData shows all data in a filtered list
ShowDataForm Show The data form associated with the given sheet
ShowLevels display outline levels
ShowPages Does pivot table stuff
SpellCheck Check the spelling of a word
SubscribeTo Subscribes to an edition
Undo Undoes the last user interface command
Ungroup Ungroup pivottable selection
Unprotect turn protection off for sheets and documents
Update tell some object to update itself
UpdateFromFile if the file on disk is more up-to-date than the given
workbook, update the workbook
UpdateLink Updates an Excel, DDE or OLE link
Verb tell an OLE object to do something
class info Get information about an object class
close Close an object
count Return the number of elements of a particular class
within an object
data size Return the size in bytes of an object
delete Delete an element from an object
duplicate Duplicate object(s)
event info Get information about the Apple events in a suite
exists Verify if an object exists
make Make a new element
move Move object(s) to a new location
open Open the specified object(s)
print Print the specified object(s)
quit Quit an application program
save Save an object
suite info Get information about event suite(s)

Klassen:
Verzeichnis _Global Anwendung
Formatvorlage Symbolleiste Symbolleistenschaltfläche AddIn Arbeitsmappe Document
Blatt Tabellenblatt Excel4Makroblatt
Excel4IntlMakroblatt PivotTabelle PivotFeld
Szenario Menüleiste Menü
ShortcutMenu Menüelement Fenster
Ausschnitt Name Graphic Object
Zeichenobjekt Graphic Shape Graphic Text Root
Graphic Rich Text Root Gruppe Linie
LinieListe Rechteck Ellipse
Bogen BogenListe Textfeld
Bild OLEObjekt Diagrammobjekt
Zeichnung ZeichnungListe Schaltfläche
Bearbeitungsfeld Kontrollkästchen Optionsschaltfläche
Drehfeld Bildlaufleiste Listenfeld
Gruppenfeld Dropdown DropdownListe
Dialog Frame Label Innenbereich
AudioNotiz Zeichen Dialog
Gliederung Modul Dialogblatt
Seiteneinrichtung character file
selection-object text text style info
insertion point

Table Suite - Classes for manipulating tables

Address Return a text representation of the name of the given range
AdvancedFilter Filter a list based on the given criteria
ApplyNames apply names of cell references to their uses
ApplyOutlineStyles apply outlining styles to the given range
AutoFill perform an auto fill
AutoFilter perform an auto filter
AutoFit Set column width or row height to an auto fit
AutoOutline create an outline for the given range or the entire
sheet
BorderAround Put a border around a range
ClearNotes Clear notes from a range of cells
ClearOutline Clear the outline of a range of cells
ColumnDifferences returns a range of cells whose contents are different
from the comparison cell
Consolidate consolidate data on multiple worksheets
CreateNames create defined names based on the given range
DataSeries enters a data series in the given range
DialogBox run an old style dialog box
LastCell Returns the cell at the end of the given range
FillDown fill a range of cells from the top down
FillLeft fill a range of cells from left to right
FillRight fill a range of cells from right to left
FillUp fill a range of cells from the bottom up
Find search for a string in some object (range, doc,
text box)
FindNext search for the next cell that contains the last
searched for string
FindPrevious search for the previous cell that contains the
last searched for string
GoalSeek perform a goal seek
Justify Justify to the object
NavigateArrow Navigates a tracer arrow
NoteText Set of get the text of a cell's note
Offset return a new range offset from the given range
Parse parse data in a cell and break it into multiple cells
RemoveSubtotal Remove subtotals from a list
Replace search for and replace a string
Resize return a new range with new dimensions
RowDifferences returns a range of cells whose contents are
different from the comparison cell
ShowDependents draws tracer arrows to dependents
ShowErrors draws tracer arrows to show erros
ShowPrecedents draws tracer arrows to precedents
Sort sort a range of cells
SortSpecial sort a range of cells
SpecialCells return a range referring to cells that match a
certain criterion
Subtotal create a subtotal
Table create a table
TextToColumns Parse a column of cells containing text into
several columns

Klassen:
FlächeListe Bereich Zelle
Zeile Spalte table

Diagrammfolge - Classes to manipulate charts:

AddChartAutoFormat create a chart auto format
ApplyDataLabels apply data labels to a chart, series or point
ChartWizard Perform a Chart Wizard
DeleteChartAutoFormat delete a chart auto format
Deselect remove the selection from a chart
ErrorBar Apply Error Bars to a chart series
ExtendSeries Add more data points to existing series of a chart
SetDefaultChart sets the chart formatting for new charts

Klassen:
Schriftart Rahmen RahmenListe
Corners Series Lines Hilo Lines
Gridlines DropLines Error Bars
Up Bars Down Bars Chart Title
Chart Text Achsentitel Floor
Walls Plot Area Chart Area
Legend Tick Labels Diagramm
Diagrammgruppe Flächengruppe Balkengruppe
Säulengruppe Liniengruppe Kreisgruppe
Ringgruppe Netzgruppe Punktgruppe
Achse Datenbeschriftung Datenpunkt
Datenreihe Legendeneintrag Legendenschlüssel
Trendlinie

Mail Suite - Apple Open Collaboration Environment related Apple Events:

ForwardMailer Sets up a workbook mailer for forwarding
LogoffMail Closes a mail session
LogonMail Opens a mail session
NextLetter Opens the next Excel letter from the In Tray
Reply Creates a workbook to reply to the given workbook
ReplyAll Creates a workbook to reply to the given workbook
Route Route the given workbook using the current routing slip
SendMailer Send object as mail
SendMail Send some mail

Klassen:
Wurfsendung Verteiler