AppleScript Reference

	Using AppleScript With Microsoft Excel A functional list of how to... information.
	Microsoft Excel 5.0 Object Model A diagram that shows the objects provided by Microsoft Excel.
	Programming Language Summary Programming language topics including suites, classes and properties. AppleScript Dictionary  A complete listing of the AppleScript dictionary in Microsoft Excel 5.
	Reference Information Reference topics including glossary, obtaining support and reference materials.


Using AppleScript

Getting Started

Files and components needed, creating a script, recording a script, and editing scripts.

Running AppleScript

Starting AppleScript.

Programming Concepts and Samples

Important programming concepts and examples of using AppleScript and Microsoft Excel together.

Debugging

Tips on debugging scripts for Microsoft Excel.

Optimization

Tips on optimizing scripts for Microsoft Excel.


Getting Started

What is needed to use AppleScript

Creating a script

Recording a script


What is needed to use AppleScript

To use AppleScript with Microsoft Excel you must have the following files installed on your Macintosh.

1.  AppleScript™ Extension

2.  Apple® Event Manager Extension

3.  Script Editor (If you desire to record scripts or create script files)

4.  Microsoft Excel for Macintosh and its supporting help files

AppleScript requires system 7.0 or greater.  To write scripts that control the Finder it may be necessary to install additional components.  See your documentation supplied with AppleScript or the System software for instructions on how to install these components.

See Also

Help

Installing Microsoft Excel

Microsoft Excel Users Guide

Chapter 1, "Installing and Starting Microsoft Excel"


Creating a script

To create a script do the following:

1.  Start the Script Editor application (supplied with AppleScript)

2.  Enter the scripting code

3.  Save the script

Sample code for step 2:

tell application “Microsoft Excel”

    Activate

    Select Sheet “Sheet1”

    Select Range “R1C3”

    set FormulaR1C1 of ActiveCell to “1”

    Select Range “R2C3”

    set FormulaR1C1 of ActiveCell to “2”

    Select Range “R1C3:R2C3”

    AutoFill Selection Destination Range “R1C3:R10C3”

end tell


Recording a script

To record an AppleScript do the following:

1.  Start the Script Editor application.  This is supplied with AppleScript.

2.  Click on the Record button.

3.  Perform the tasks desired.  This often requires launching the application for which you are planning to record the script.  If the application is already open you simply need to switch to the application.

4.  Switch back to the Script Editor and press the Stop button.


Running AppleScript

Running AppleScript is simply a matter of starting your AppleScript editing application.  The Script Editor Application is supplied by Apple Computer with the AppleScript product.  For purposes of simplicity any references to a script editing application made in this help file will be referring to the Script Editor application supplied by Apple Computer.  You should be sure to install all the necessary AppleScript components before attempting to create scripts.

See What is needed to use AppleScript:


Programming Concepts and Samples

Microsoft Excel provides a robust object model for scripting applications. The topics listed below provide many examples on how to use AppleScript and Microsoft Excel together. In addition to the examples several important concepts are addressed.

Accessing Microsoft Excel from AppleScript

Accessing AppleScript from Microsoft Excel


Accessing Microsoft Excel with AppleScript
Accessing Microsoft Excel from AppleScript

Microsoft Excel provides a robust scripting object model for use with AppleScript.  Wherever possible the AppleScript object model of Microsoft Excel version 5 was designed to match the Visual Basic for Applications object model of Microsoft Excel version 5.  The most notable exception to this are the cases where AppleEvents were included for compatibility with Microsoft Excel version 4.  Other AppleEvents are included to support the core AppleEvents that are required for compatibility with AppleScript.

Interacting with Excel from within AppleScript

There are several common issues that are important for those writing scripts that interact with Microsoft Excel.  Below are the most common issues.

Workbook Model:	Understanding the Workbook object.

Referencing:	Referencing cells and ranges within Microsoft Excel.

Running Macros:	Executing Microsoft Excel macros from within AppleScript.


Workbook Model:

One of the most commonly used classes in Microsoft Excel version 5 is the Workbook class.  Workbooks differ from documents in most other applications because a workbook can store several different sheet types.  These sheet types include Worksheets, Charts, Modules, Dialogs, Excel4Macrosheets and Excel4IntlMacroSheets.  Other applications such as word processors typically have documents that either contain the word processing document or possibly a macro sheet but not both simultaneously.

All Microsoft Excel 5 documents are workbooks.  This is in contrast to version 4, where each document type was usually (though not always) a separate document.  When writing scripts in version 5 you will use the Workbook class for most (but not all) document manipulation.  It is recommended that you compare the AppleScript Dictionary entries for the Document and Workbook classes.


Referencing:

Microsoft Excel is able to reference cells or ranges in two different ways.  The first, A1 notation, is the most common.  This referencing scheme uses letters to address the columns and numbers to address the rows.  The other method is referred to as R1C1.  In this method both the rows and the columns are addressed by numbers, however, the numbers are preceded by either an R or a C to designate rows and columns.  The row designation will always precede the column designation.  Examples of the two referencing methods are:

Example	A1 Reference	R1C1 Reference
Single Cell	C9	R9C3
Range	C9:E20	R9C3:R20C5
Active Cell	n/a	RC
Relative Reference	J224	R[1]C[-3]
Absolute Reference	$J$224	R29C35
Mixed Reference	$D4	R[3]C10

In the first two examples above the A1 style reference and the R1C1 style references refer to the same cell or range.  All remaining examples the references do not refer to the same cells or ranges however they do illustrate the different reference styles.

NOTE:  When referencing cells or ranges in Microsoft Excel from AppleScript it is necessary to use the R1C1 style of reference.  Using the A1 style of referencing or relative R1C1 references will generate an error.

See Also

Microsoft Excel Users Guide

Chapter 10, "Creating Formulas and Links", Pages 132-138


Running Macros:

Commands to run Microsoft Excel macros from AppleScript

Script examples for use with Microsoft Excel version 4

Script examples for use with Microsoft Excel version 5

Handling errors when running macros


Commands to run Microsoft Excel macros from AppleScript

There are two commands provided by Microsoft Excel to AppleScript that can be utilized to execute a macro. These two commands are:

1. do script <text expression>

2. Evaluate <text expression>

where <text expression> is a text string argument that Microsoft Excel will evaluate in order to perform the requested action. In both cases, <text expression> can be almost any valid Microsoft Excel function or macro expression.

Both of the above commands have similar syntax and functionality with respect to issuing stand-alone expressions. For example, the following two statements have identical results:

1. do script "SUM(2,3)"

2. Evaluate  "SUM(2,3)"

In both cases, the value five (5) is returned to the special AppleScript variable called result. The following two commands also function identically:

1. do script "select(\"r1c1:r1c3\")"

2. Evaluate  "select(\"r1c1:r1c3\")"

The net result for the latter pair of commands is to set the selection on the active sheet to the cell range A1:C1.

NOTE: All cell references sent to Microsoft Excel from AppleScript must be in R1C1 notation. Also note that quotation marks that are embedded within a text string must be preceded by a backslash. The syntax and limitations for the above two commands does vary with respect to calling a user-defined macro that exists within a Microsoft Excel document.


Script examples for use with Microsoft Excel version 4

The following information will provide examples of calling Microsoft Excel macros from AppleScript. Following each example will be a brief explanation of syntax and limitations.

Assuming that the document containing the macro is currently open in Microsoft Excel, the following examples are valid:

1. do script "macro1!test1()"

2. do script "macro1!test1(5)"

3. copy 7 to x

   do script "macro1!test1(" & x & ")"

The above command runs a macro defined with the name test1 on the open macro sheet named macro1. The macro sheet name, exclamation point, macro name, and parentheses are required. If the macro accepts an argument, that argument can be placed within the parentheses, as shown in example 2.  The command in example 3 runs the same macro described in example 1, but passes the value seven (7) to the macro. The value seven (7) is contained in the AppleScript variable x.

4. do script "macro1!r1c1()"

5. do script "[Workbook1]macro1!test1()"

The above command runs a macro beginning at cell A1 of the macro sheet named macro1. The macro need not be defined as a command macro. Arguments can be passed using the same syntax presented in examples 2 & 3. Example 5 runs the same macro as example 1, assuming that the macro sheet macro1 is a bound sheet within the workbook Workbook1. This syntax will result in an error if macro1 is an unbound sheet. In this case, use the syntax described in example 1. Passing arguments follows the same conventions as examples 2 & 3.

6. Evaluate "run(\"test1\")"

7. Evaluate "run(macro1!test1)"

The above command runs macro named test1, assuming that it is defined on the active macro sheet. Example 7 runs the same macro as example 1, assuming the sheet macro1 is already open.

The following examples do not require the macro sheet containing the macro to be open, provided the macro sheet exists in the current working folder, and another file of the same name is not already open.

 8. Evaluate "run(\"macro1!test1\")"

 9. Evaluate "run(\"macro1!r1c1\")"

10. Evaluate "run(macro1!test1(5))"

The above command runs the macro named test1 which is defined on the macro sheet named Macro1. If Macro1 is not open, Microsoft Excel will open it provided it exists in the current working folder. Example 9 runs the macro beginning at cell A1 on the macro sheet named macro1. If Macro1 is not open, Microsoft Excel will open it provided it exists in the current working folder. Example 10 runs the same macro as example 1, but passes the value five (5) to the macro. The document macro1 must already be open.

11. Evaluate "macro1!test1"

The above command functions identically to example 6.

12. Evaluate "macro1!test1(5)"

The above command functions identically to example 9.

13. Evaluate "macro1!r1c1"

The above command runs the same macro as example 8, assuming that the document macro1 is already open.

14. Evaluate "macro1!r1c1(5)"

The above command runs the macro beginning in cell A1 of the macro sheet macro1 and passes the value five (5) to the macro. The macro sheet macro1 must already be open.

Microsoft provides AppleScript examples for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. These AppleScript examples are provided 'as is' and Microsoft does not guarantee that it can be used in all situations. Microsoft does not support modifications of this procedure to suit customer requirements for a particular purpose.


Script examples for use with Microsoft Excel version 5

The following information will provide examples of calling Microsoft Excel version 5 macros from AppleScript. Following each example will be a brief explanation of syntax and limitations.

The syntax for calling a macro written in the Microsoft Excel 5.0 macro language from AppleScript is essentially the same as Microsoft Excel version 4, with the following exception: If the macro is not in the active workbook, you must use the workbook name in the reference to the macro. For example:

Evaluate "run(\"Workbook1!test1\")”

The above example assumes that the name for macro test1 is defined as a global name in Workbook1. If this is not the case, then use syntax similar to the following:

Evaluate "run(\"[Workbook1]Macro2!test2\")"

The above will be necessary especially when two macros are defined with the same name and exist within the same workbook. In the above example, Workbook1 is the name of the workbook, Macro2 is a macro sheet within that workbook and contains the macro named test2.

Calling Visual Basic, Applications Edition, Subroutines And Functions

The syntax for calling Microsoft Excel 5.0 Visual Basic subroutines and functions is similar to the syntax described above for Microsoft Excel 4.0 and macros, with the following exceptions:

1. Even if the module sheet containing the subroutine or function is the activesheet, you must specify, at minimum, the module sheet name. For example:

do script "Module1!MySub()"

If MySub is a unique identifier within its parent workbook, you can use the workbook name and exclude the module name as in the following:

Evaluate "Workbook1!MySub()"

2. You must include parentheses, even if your subroutine or function does not accept any arguments.

Return Values

The values returned by macros and functions in Microsoft Excel vary depending on the version and type of function or subroutine called. The topics below describe each type in detail.

Microsoft Excel 4.0 Macro Language

Visual Basic for Applications Edition Subroutines

Visual Basic for Applications Edition Functions

Microsoft provides AppleScript examples for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. These AppleScript examples are provided 'as is' and Microsoft does not guarantee that they can be used in all situations. Microsoft does not support modifications of this procedure to suit customer requirements for a particular purpose.


Microsoft Excel 4.0 Macro Language

It is recommended, but not required, that a Microsoft Excel macro invoked from AppleScript return a value. If the macro ends with the RETURN function, but does not return a value, an error will be returned to AppleScript from Microsoft Excel. Handling errors is described in a section below. It may, in fact, be desirable for your macro to return a value that your AppleScript script can process. The following are examples of Microsoft Excel macro code, and a description of the side effects when that code is invoked from an AppleScript script.

1. =ALERT("Run From AppleScript")

   =RETURN(TRUE)

The macro above will, after displaying the alert message, return the boolean value TRUE to AppleScript. This is also the value returned automatically by a Visual Basic subroutine in Microsoft Excel 5.0 (described in more detail below). If your macro does not need to return a specific value other than TRUE, it is recommended that TRUE be used as the return value to ensure consistency with Microsft Excel 5.0 Visual Basic subroutines. The value returned can be any numeric, boolean, or string expression.

2. =ALERT("Run From AppleScript")

   =RETURN()

The macro above will, after displaying the alert message, cause an error to be returned to the calling AppleScript script from Microsft Excel. Handling this error condition is described in a section below.

3. =ALERT("Run From AppleScript")

   =HALT()

The macro above will, after displaying the alert message, terminate normally and cause the boolean value false to be returned to AppleScript.

4. =ALERT("Run From AppleScript")

The macro above will, after displaying the alert message, cause an error message to be displayed in Microsoft Excel (requiring the user to interact with the message). After the error message is dismissed, the boolean value false is returned to AppleScript (unless a timeout has occurred).

5. =ERROR(FALSE)

   =ALERT("Run From AppleScript")

The macro above will, after displaying the alert message, terminate normally and return the Boolean value false to AppleScript. The command ERROR(FALSE) disables the error message that Microsoft Excel would normally display because it did not encounter a RETURN() or HALT() in the macro.


Visual Basic for Applications Edition Subroutines
Visual Basic for Applications Subroutines

A Visual Basic macro in Microsoft Excel 5.0 is only capable of returning two values, the Boolean values TRUE and FALSE, to AppleScript. The Boolean value true is returned when the subroutine completes successfully. The Boolean value false is returned when the subroutine terminates abnormally, due to a run-time error or a user interrupt.


Visual Basic for Applications Edition Functions
Visual Basic for Applications Functions

A Visual Basic function can return any numeric, Boolean, or string expression to AppleScript. If no value is explicitly returned by the function, the real value zero (0.0) is returned. If the function terminates abnormally, due to a run-time error, the Boolean value FALSE is returned to AppleScript. All numeric data returned to AppleScript will be of the AppleScript data type real.


Handleing errors when running macros
Handling errors when running macros

Handling Errors

Should you find yourself in a situation where you encounter an error, AppleScript has some mechanisms in place for handling this event, without causing your AppleScript script to terminate abnormally. The information presented in this section describes commands that are specific to the product AppleScript version 1.1, provided by Apple Computer, Incorporated, and may change at any time. Microsoft Corporation has no control over the syntax or functionality of the AppleScript commands described in this section. Microsoft Corporation also makes no claims as to the validity of the commands described in this section if you are using a scripting system other than AppleScript.

Ignoring Application Responses

Consult your AppleScript documentation for more information about the ignoring (or considering) qualifier. Example:

tell application "Microsoft Excel"

    ignoring Application Responses

       do script "workbook1!mySub()"

    end ignoring

end tell

The above example tells Microsoft Excel to execute a macro named mySub contained in the document workbook1. However, because AppleScript has been instructed to ignore Application Responses, AppleScript will not wait for Microsoft Excel to complete execution of the macro and return a value. Any value returned by the macro will be ignored. Using this method, it is possible for AppleScript to continue processing the rest of the script, following the call to the macro, and may in fact complete execution of the script before Microsoft Excel finishes executing the macro. try ... on error.

Consult your AppleScript documentation for more information about the try statement error handler.

Example:

tell application "Microsoft Excel"

   try

      do script "Macro1!myMacro()"

   on error myErrorText number myErrorNumber

      display dialog MyErrorText & return & (myErrorNumber as string)

   end try

end tell

The above example tells Microsoft Excel to execute a macro named myMacro contained on the macro sheet Macro1. This time, if an error occurs as the result of executing the macro, the lines between on error and end try are executed. Below is a description of what these lines do.

1. on error myErrorText number myErrorNumber

The above statement places a descriptive error message as a text string into the user-defined AppleScript variable myErrorText. It also places an error number into the user-defined AppleScript variable myErrorNumber.

2. display dialog MyErrorText & return & (myErrorNumber as string)

The above statement, since it is contained within the on error clause of the try statement, is only executed when an error results. In this example, it displays the descriptive error message retrieved in step 1, above, on the first lines of a dialog box. It also displays the error number retrieved in step 1, above, on the last line of the same dialog box.

Additional Example

The following example demonstrates using error handling to ensure smooth operation of a script which calls a Microsoft Excel 5.0 Visual Basic.  In this example, a macro named RunFromAS is saved within a workbook file named MacroBook. MacroBook is saved on the Desktop.  The script checks if MacroBook is open before calling the macro. If it is not open, an attempt is made to open it. If it can not be opened, an error message is displayed, but the script does not terminate abnormally.

If MacroBook is opened successfully, or it is already open, then an attempt is made to run the macro RunFromAS. If and error is encountered at this point, a message is displayed, but the script does not terminate abnormally.

tell application "Microsoft Excel"

Activate

set runIt to true

if not (exists Workbook "MacroBook") then

try

Open "Macintosh HD:Desktop Folder:MacroBook"

on error myErrorText

set runIt to false

display dialog myErrorText buttons "OK" default button 1

end try

end if

if runIt then

try

do script "MacroBook!RunFromAS()"

on error myErrorText

display dialog myErrorText buttons "OK" default button 1

end try

end if

end tell

NOTES:

1.  The error number returned from Microsoft Excel when a macro terminates without returning an explicit value is -1708.

2. display dialog is an AppleScript command whose functionality is provided by a Scripting Addition. A Scripting Addition is an add-on to the AppleScript scripting environment. The scripting addition display dialog is provided by Apple Computers, Inc. It should be located within the Scripting Additions folder, which is located inside the Extensions folder inside your System Folder.

Microsoft provides AppleScript examples for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. These AppleScript examples are provided 'as is' and Microsoft does not guarantee that they can be used in all situations. Microsoft does not support modifications of this procedure to suit customer requirements for a particular purpose.


Accessing AppleScript with Microsoft Excel
Accessing AppleScript from Microsoft Excel

To run AppleScript applications from within Microsoft Excel it is necessary to use the Visual Basic for Applications MacScript function.

Description

Runs an AppleScript and (optionally) returns a result as a text string.

Syntax

MacScript  script

Remarks

The script argument can be either a fully qualified path to an AppleScript application file, a fully qualified path to a script saved in a text file, or the actual script text itself.  For example:

Example 1:

'This subroutine will run the script called Sample Script  This file can

'be either a compiled script application or an equivalent AppleScript text file.

Sub RunScript()

MacScript "Macintosh HD:Script Folder:Sample  Script"

End Sub

Example 2:

'This subroutine will run the script called Sample  Script   This file can

'be either a compiled script application or an equivalent AppleScript text file.

'The script will return a result, which will be displayed.  Note that when using the

'MacScript function to return a value, the script argument must be contained

'within parenthesis (as shown in the example below).

Sub runScript2()

Dim Str As String

Str = MacScript("Macintosh HD:Script Folder:Sample Script")

Msgbox Str

End Sub

Example 3:

'This subroutine will run a Hard Coded script that will return

'the name of the floppy disk (if there is one in the floppy drive)

Sub RunScript3()

Dim Str As String

Dim Temp As String

Dim CR As String

CR = chr$(13)

Str = ""

Str = "tell application ""Finder"""

Str = Str & CR & "set FloppyName to every" & _

" disk whose capacity <2000000"

Str = Str & CR & "end tell"

Temp = MacScript(Str)

MsgBox "Floppy Name= " & Temp

End Sub

NOTES:

1.  You can separate AppleScript commands with the chr$(13) (carriage return).

2.  To place a quotation mark character in a text string use two quotation mark characters in a row.

3.  Example 3 requires the scriptable finder.

4.  Microsoft Excel version 4 cannot run scripts.

Microsoft provides AppleScript and Visual Basic examples for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. These AppleScript and Visual Basic examples are provided 'as is' and Microsoft does not guarantee that they can be used in all situations. Microsoft does not support modifications of this procedure to suit customer requirements for a particular purpose.


Debugging

The following are common issues to review when debugging when using AppleScript and Microsoft Excel.

1.  Referencing

2.  Focus of command

3.  Errors


Referencing Problems

There are two common referencing problems when scripting Microsoft Excel.

Document VS Workbook

The Microsoft Excel version 5 workbook is a document that can contain four different sheet types.  Because of this, the workbook structure is different than most other applications which manipulate documents that are more simple in structure.  It is recommended that you compare the AppleScript Dictionary entries for the Document and Workbook classes.  See also: Workbook Model.

A1 VS R1C1

Microsoft Excel requires that all references to ranges or cells be in the R1C1 format.  To learn more about the R1C1 format see: Referencing


Focus of command
Referencing objects

It is important to reference the correct object when scripting Microsoft Excel.  A common mistake is to attempt to use the Document class to access a workbook when the Workbook class should be used.

Example1:

Get FileFormat of Document "Workbook1"	--This will not work

Example2:

Get FileFormat of Workbook "Workbook1"	--This will work

If you are accustomed to scripting other applications it would seem natural that Example 1 would return the file format of Workbook1.  However, this is not the case since the Document class does not contain the FileFormat property.  The Document class has a Type property which is similar to the FileFormat property but is a property that is more useful in Microsoft Excel version 4.

Another example would be the Chart object and the ChartObject object.  The Chart object is used to manipulate sheets of the Chart type whereas the ChartObject manipulates embedded charts within a worksheet.

Because of the complexity of the object model it is recommended that you study the Microsoft Excel Object Model and the Microsoft Excel AppleScript Dictionary.


Errors

When determining the cause of an error it is important to localize the error to a specific statement.  If the statement is complex it may be necessary to simplify the statement by breaking it down into smaller statements that are then combined to form the final complex statement.  For example, lets assume we have an AppleScript statement that is returning an error.  In example 1 we have a single AppleScript statement instructing Microsoft Excel to open a workbook, but it does not work.  In example 2 the statement is broken into pieces to make it easier to find the problem.  After evaluating the result of each line in example 2 we notice that there is no colon between the path and the file name.  This would have been much harder to find without breaking the statement into smaller statements.

Example1:

Open "Macintosh HD:Microsoft Office:Microsoft Excel" & text returned of (display dialog "Enter a Workbook name to open" buttons {"OK", "Cancel"} default answer "Workbook")

Example2:

set ThePath to "Macintosh HD:Microsoft Office:Microsoft Excel"

set WorkbookName to text returned of (display dialog "Enter a Workbook name to open" buttons {"OK", "Cancel"} default answer "Workbook")

set FullName to ThePath & WorkbookName

Open FullName


Optimization

Below are principles for optimizing an AppleScript application that uses Microsoft Excel.

1.  Evaluate what is being done, and if necessary call Visual Basic for Applications subroutines (or the XLM macro language if in Microsoft Excel version 4).  As with most applications it is often faster to call an internal macro language than it is to send AppleScript commands to that application to accomplish a task.  This is mostly due to the overhead involved with the sending of AppleEvents.  When an AppleScript application is executing it sends AppleEvents to the various applications it is using.  While this overhead is usually minimal, it can add up to a significant amount of time if a complex process is being executed (most notably a process that repeats a particular operation many times).

2.  Minimize data being passed between AppleScript and other applications.  Consider the following examples.  These examples each look for a cell containing the text Yes.

Example1:

if (Cell "R1C1:R40C12" of Sheet "Sheet1" of Workbook "Workbook1" contains "Yes") then beep

Example2:

set TheCell to (Find every Cell What "Yes" without activate and MatchCase)

In Example 1 the contents of the cells R1C1:R40C12 (A1:L40) must be sent to the AppleScript application for examination.  This can result in a large amount of data, which could cause errors (in this case you would probably encounter an Out of memory error).  Example 2 uses a built in method to find the data.  This method does not require the data to be sent to AppleScript which results in faster execution and fewer errors.


Microsoft Excel 5.0 Objects

Shown below is the Microsoft Excel 5.0 Object model.  This limited version is for visualization purposes only.  A complete object model with complete help text can be found by opening the Visual Basic Reference help file and selecting the Microsoft Excel Object Model topic.  The Visual Basic Reference help file is part of the Microsoft Excel product.


WorksheetObject


ChartsheetObject


DialogsheetObject


Programming Language Summary

Suites

Classes

Properties

Elements


Suites

AppleScript suites are groups of objects (or classes) and the commands available to act on those objects.  Shown below are the suites available within Microsoft Excel.

Required Suite: Events that every application should support

Miscellaneous Standards Suite: Miscellaneous standard events and classes

Core Suite: Suite that applies to all applications

Table Suite: Classes for manipulating tables

Charting Suite: Classes to manipulate charts

Mail Suite: Apple Open Collaboration Environment related Apple Events


Classes

A class is a category of objects which share related characteristics.  Examples of related characteristics are properties, elements and commands.


Properties

Properties are named attributes of objects.  Properties define object characteristics (such as size, color, and screen location) or object behaviors (for example, whether the object is enabled).  You can use the AppleScript dictionary  to see the objects available within Microsoft Excel.


Microsoft Excel 5 Dictionary

To view the AppleScript Dictionary using Script Editor:

1.  Start the Script Editor.

2.  From the File Menu, choose Open Dictionary.

3.  In the dialog box presented, change to the folder containing the Microsoft Excel application.

4.  Select the Microsoft Excel application and click the Open button.

To view the Microsoft Excel 5 Dictionary select the desired suite below.

Required Suite

Miscellaneous Standards Suite

Core Suite

Table Suite

Charting Suite

Mail Suite


AppleScript Dictionary

A list of commands, classes and objects provided by an application for use by AppleScript.


Workbooks

Fundamental Microsoft Excel 5 document.  A workbook can contain any combination of the following types of sheets: Worksheets, Charts, Modules, Dialogs, Excel4Macrosheets and Excel4IntlMacroSheets.


Reference Information

Obtaining support

Reference materials


# Glossary$ GlossaryK Glossary+ AETEST2:000500


Obtaining support

Listed below is a summary of support options offered to assist on how to use the product.  The full descriptions for these topics can be obtained by either pressing Command+/ with any worksheet active or by choosing Microsoft Excel Help from the Help menu.

Electronic Services

Using Automated Telephone or Fax Support

Using the Microsoft Forums on Compuserve

Using the Microsoft Download Service

Using the Internet Network

Telephone Support

Calling Microsoft Product Support Services in the United States or Canada

See Also

Help

Types of Technical Support

User's guide

"Microsoft Support Services"


Reference materials

Listed below is a summary of additional reference materials for AppleScript and Microsoft Excel.

Microsoft Excel Version 5 Users Guide

Microsoft Excel Version 5 Visual Basic Users Guide

AppleScript Language Guide

AppleScript Scripting Additions Guide

AppleScript Software Developers Kit


Telephone or Fax Support
Using Automated Telephone or Fax Support

If you have a touch-tone telephone, you can hear recorded responses in English to common Microsoft Excel questions 24 hours a day, seven days a week on Microsoft FastTips.  You can also order technical notes in English that will be sent to your fax machine.

To reach FastTips for Microsoft Excel, call (800) 936-4100.

See Also

Help

Types of Technical Support

User's guide

"Microsoft Support Services"


Compuserve
Using the Microsoft Forums on Compuserve

You can interact with other users and Microsoft support engineers or access the Microsoft Knowledge Base to get product information on several Compuserve forums.  Compuserve is available 24 hours a day, seven days a week, including holidays.

At any ! prompt, do the following:

•	To access Microsoft forums, type go Microsoft

•	To access the Microsoft Knowledge Base, type go mskb

For an introductory CompuServe membership kit specifically for Microsoft users, please call (800) 848-8199 and ask for operator 519.

See Also

Help

Types of Technical Support

User's guide

"Microsoft Support Services"


Microsoft Download Service
Using the Microsoft Download Service

If you have a modem, you can download the most current technical notes, supplementary files, and the Driver Library for Microsoft Excel from the Microsoft Download Service. This service is available 24 hours a day, seven days a week, including holidays.

To reach the Microsoft Download Service, please call (206)  936-6735 via modem (1200, 2400, or 9600 baud; no parity; 8 data bits; 1 stop bit).  In Canada, call (905)  507-3022.

See Also

Help

Types of Technical Support

User's guide

"Microsoft Support Services"


Internet Network
Using the Internet Network

You can access the Microsoft Knowledge Base and the Driver Library by using Internet.  This service is available 24 hours a day, seven days a week, including holidays.

The Microsoft Internet FTP archive host, ftp.microsoft.com, supports anonymous logon.  When logging on as anonymous, you should type your complete electronic mail name as your password.

The Microsoft World Wide Web site, http://www.microsoft.com can also be used to obtain additional information including support information.

See Also

Help

Types of Technical Support


Calling Microsoft Product Support Services in the United States or Canada

Calling Microsoft Product Support Services in the United States and Canada

If you have a question about Microsoft Excel, look in the Microsoft Excel User's Guide, consult on-line Help, or see Answers to Common Questions about Microsoft Excel. You can find late-breaking updates and technical information by double-clicking the Microsoft Excel Readme Help icon in the Microsoft Excel program group. If you cannot find the answer, you can telephone Microsoft support engineers available through the Microsoft Support Network.

Calling the Microsoft Support Network

When you call, you should be at your computer and have the appropriate product documentation at hand. Be prepared to give the following information:

•	The version number of Microsoft Excel that you are using

•	The type of hardware that you are using, including network hardware, if applicable

•	The operating system that you are using

•	The exact wording of any messages that appeared on your screen

•	What happened and what you were doing when the problem occurred

•	How you tried to solve the problem

Use the System Info feature to view information about your system

The System Info feature examines your computer and displays information about Microsoft Excel and your operating system, including fonts, printing, proofing tools, graphics filters, text converters, OLE applications, and screen display. This information might be useful to the technical support technician, should you need to call for assistance.

To see information with the System Info feature

1. From the Help menu, choose About Microsoft Excel.

2. Choose the System Info button.

3. In the Choose A Category box, select the type of information you want.

You can also save or print information and run programs from the System Info dialog box.

Getting standard support

No-charge support from Microsoft support engineers is available via a toll call between 6:00 A.M. and 6:00 P.M. Pacific time, Monday through Friday, excluding holidays.

In the United States, to reach support staff familiar with Microsoft Excel, call (206) 635-7070.

In Canada, support engineers are available via a toll call between 8:00 A.M. and 8:00 P.M. Eastern time, Monday through Friday, excluding holidays. Call (905) 568-3503.

Getting priority support

The Microsoft Support Network offers priority telephone access to Microsoft support engineers 24 hours a day, seven days a week, excluding holidays.

•	In the United States, call (900) 555-2000; $2 per minute, $25 maximum. Charges appear on your telephone bill. Not available in Canada.

•	In the United States, call (800) 936-5700; $25 per incident, billed to your VISA, MasterCard, or American Express credit card. In Canada, call (800) 668-7975; $30 per incident, billed to your VISA card, MasterCard, or American Express Card.

Suggesting a new Microsoft Excel feature

If you want to suggest a new feature or feature enhancement for Microsoft Excel, please call (206) 936-WISH  or  (206) 936-9474.

See Also

Microsoft Excel Help

Answers to Common Questions About Microsoft Excel

Getting Product Support for the Deaf and Hard of Hearing  with a Text Telephone (TT/TDD) Service

Locating Product Training and Consultation Services

Other Support Options

Using Automated Telephone Support and Fax Services

Using the Microsoft Download Service

Using the Microsoft Forums on CompuServe

Using the Internet Network

User's Guide"Microsoft Support Services"


Answers to Common Questions about Microsoft Excel

To view answers to common question about Microsoft Excel select the Technical Support topic in the main Microsoft Excel help screen.  This can be accessed by pressing · + / from any worksheet.


Required Suite:

Defines events that every application should support

open: Open the specified object(s)

open  alias  -- list of objects to open

print: Print the specified object(s)

print  alias  -- list of objects to print

quit: Quit application

quit

run: Sent to an application when it is double-clicked

run


Miscellaneous Standards Suite

Defines miscellaneous standard events and classes

There are no events defined in this suite in Microsoft Excel 5.


Core Suite

Defines a Suite that applies to all applications

Activate: Activate the object

Activate  reference  -- object to activate

ActivateMicrosoftApp: Activate some Microsoft application

ActivateMicrosoftApp

Index  xlMicrosoftWord/xlMicrosoftPowerPoint/xlMicrosoftMail/xlMicrosoftAccess/xlMicrosoftFoxPro/xlMicrosoftProject/xlMicrosoftSchedulePlus  -- the application to activate

Result:   boolean  -- application was successfully activated

ActivateNext: Activate the window following the given window

ActivateNext  reference  -- object to activate

ActivatePrevious: Activate the window preceding the given window

ActivatePrevious  reference  -- object to activate

AddCustomList: create a new custom list

AddCustomList

ListArray  anything  -- list of strings of the list or a range which contains the items

[ByRow  boolean]  -- if item is a range then import data from rows

AddFields: Add fields to a pivot table

AddFields  reference  -- the pivot table to add the fields to

[RowFields  text]  -- fields to add to rows of the pivot table

[ColumnFields  text]  -- fields to add to columns of the pivot table

[PageFields  text]  -- fields to add to pages of the pivot table

[AddToTable  text]  -- Specify whether to create new fields or replace existing fields

AddItem: Add a new item to a listbox

AddItem  reference  -- the listbox to which the item will be added

Text  text  -- the string to add to the list box

[Index  integer]  -- position to add the item

AddMenu: Creates a new submenu

AddMenu  reference  -- The menu items collection this submenu will join

Caption  text  -- The caption for the new submenu

[Before  anything]  -- The name, index or reference of item before which to create new item

[Restore  boolean]  -- Restore the default submenu with given caption?

Result:   reference  -- the object created

AddVertex: Append a new vertex to the end of the given polygon

AddVertex  reference  -- the drawing to which a vertex will be added

Left  fixed  -- horizontal coordinate for vertex

Top  fixed  -- vertical coordinate for vertex

Arrange: Arrange all windows or all windows belonging to a document

Arrange  reference  -- windows to arrange

[Style  xlTiled/xlHorizontal/xlVertical/Reserved/Reserved/Reserved/xlCascade]  -- how to arrange the windows, default is tiled

AutoFormat: apply an auto format

AutoFormat  reference  -- The range or chart to get formatted

[As  xlDefaultAutoFormat/Reserved/xlArea/xlBar/xlColumn/xlLine/xlPie/xlDoughnut/xlRadar/xlXYScatter/xlCombination/xl3DArea/xl3DBar/xl3DColumn/xl3DLine/xl3DPie/xl3DSurface/xlCustom]  -- the chart type (e.g. bar, column, three D bar) required when formatting a chart

[Format  anything]  -- name or number of format to use (required for charts)

[Number  boolean]  -- apply the number formatting of this format

[Font  boolean]  -- apply the font formatting of this format

[Alignment  boolean]  -- apply the alignment formatting of this format

[Border  boolean]  -- apply the border formatting of this format

[Pattern  boolean]  -- apply the pattern formatting of this format

[Width  boolean]  -- apply the width formatting of this format

Cancel: tell some object to cancel itself

Cancel  reference  -- the object to cancel itself

ChangeFileAccess: Change the access permissions for the workbook

ChangeFileAccess  Workbook  -- the workbook for whom to change permissions

Mode  xlReadWrite/xlReadOnly  -- new permissions

[WritePassword  text]  -- the password when write reserved

[Notify  boolean]  -- give notification if file cannot be immediately accessed?

ChangeLink: Change a link from one document to another

ChangeLink  Workbook  -- the workbook whose link to change

Name  text  -- name of link to change

NewName  text  -- the new name for the link

[type  xlExcelLinks/xlOLELinks]  -- link type

ChangeScenario: Change the changing cells and values of a scenario

ChangeScenario  Scenario  -- the scenario to change

ChangingCells  Range  -- the new changing cells

[Values  fixed]  -- the values of the changing cells

Clear: Clear some object

Clear  reference  -- the object to clear

ClearArrows: Clear arrows from a worksheet

ClearArrows  reference  -- the object to clear

ClearContents: Clear the contents of some object

ClearContents  reference  -- the object to clear

ClearFormats: Clear formatting of some object

ClearFormats  reference  -- the object to clear

Close: close an object

Close  reference  -- the object to close

[saving  ///Save objects now/Do not save objects/Ask the user whether to save]  -- save changes?

[saving in  alias]  -- the file into which to save the object

[RouteWorkbook  boolean]  -- should the workbook be routed?

ConvertFormula: convert formula between different reference styles

ConvertFormula  reference

[Formula  text]  -- formula to convert

[FromReferenceStyle  xlR1C1/xlA1]  -- input reference style

[ToReferenceStyle  xlR1C1/xlA1]  -- ouput reference style

[ToAbsolute  xlAbsolute/xlAbsRowRelColumn/xlRelRowAbsColumn/xlRelative]  -- whether or not to make references absolute

[RelativeTo  text]  -- the cell to which the formula should be relative

CopyFace: Copy the face of a toolbar button

CopyFace  ToolbarButton  -- toolbar button whose face to copy

CopyObject: copy an object

CopyObject  reference  -- the object to copy

[To  reference]  -- the object to which to copy another object

[Before  integer]  -- the toolbar button before which to copy a toolbar button

[After  reference]  -- the object after which to copy

Result:   reference  -- the new object

CopyPicture: Copy the object

CopyPicture  reference  -- object to copy

[Appearance  xlScreen/xlPrinter]  -- copy a picture rather than data to the clipboard

[Format  xlPicture/xlBitmap]  -- copy a picture or a bitmap

[Size  xlScreen/xlPrinter]  -- size picture as on screen or as printed

Create: Creates a new element.

Create

[New  type class]  -- The class of the new element

[At  location reference]  -- The location at which to insert the element

[With Data  anything]  -- The initial data for the element

[With Properties  record]  -- Any additional parameters that are needed or allowed

[Parent  reference]  -- The parent container of the new object

[ObjectName  text]  -- The name for the new object

[Type  xlWorksheet/xlChart/xlExcel4MacroSheet/xlExcel4IntlMacroSheet/Reserved/xlModule/xlDialogSheet]  -- type of sheet to insert

[Count  integer]  -- how many objects to create

[BasedOn  Range]  -- a cell on which to base a new style

[Before  integer]  -- the index of an item before which to create a new item

[After  integer]  -- the index of an item after which to create a new item

[Template  xlWorksheet/xlChart/xlExcel4MacroSheet/xlExcel4IntlMacroSheet]  -- the name of a template or a constant

[Source  Range]  -- the source of the data for a new series

[RowCol  xlRows/xlColumns]  -- data is in rows or columns

[SeriesLabels  boolean]  -- the data contains series labels

[CategoryLabels  boolean]  -- the data contains category labels

[Replace  boolean]  -- replace existing series

[ClassType  text]  -- class type

[Filename  alias]  -- object filename

[Link  boolean]  -- if object should be linked

[DisplayAsIcon  boolean]  -- if object should be displayed as an icon

[IconFileName  alias]  -- icon filename

[IconIndex  integer]  -- icon index

[IconLabel  text]  -- icon label

[Restore  boolean]  -- Restore the default submenu with given caption?

[CopyFile  boolean]  -- copy add-in to local add-in directory

Result:   reference  -- the newly created object

CreatePublisher: create a new publisher for the given range

CreatePublisher  reference  -- the range in which to create the publisher

[Edition  text]  -- the name of the edition to create

[Appearance  xlScreen/xlPrinter]  -- publish image as shown on screen of printer

[ContainsPICT  boolean]  -- publish PICT format

[ContainsBIFF  boolean]  -- publish BIFF format

[ContainsRTF  boolean]  -- publish RTF format

[ContainsVALU  boolean]  -- publish VALU format

Result:   reference

CreateSummary: create a summary report for the scenarios on a worksheet

CreateSummary  reference  -- the scenarios to create a report from

[ReportType  xlStandardSummary/xlPivotTable]  -- the type of report to create

[ResultCells  Range]  -- result cells on the summary report

Result:   Worksheet  -- the newly created worksheet with the summary report

CustomListContents: return the contents of the given custom list

CustomListContents

[ListNumber  integer]  -- the list whose number to return

Result:   text  -- the contents of the given custom list

CustomListNumber: the number of the given custom list

CustomListNumber

[ListArray  text]  -- the list whose number to return

Result:   integer  -- the number of the given custom list

cut: Cut the object

cut  reference  -- object to cut

[To  Range]  -- the object to which to cutanother object

DDE: perform some DDE command

DDE  xlExecute/xlInitiate/xlPoke/xlRequest/xlTerminate  -- the DDE command to perform

[channel  integer]  -- the channel number, returnd by DDE Initiate

[message  text]  -- the message defined by the receiving application

[ApplicationNamed  text]  -- the application to initiate DDE with

[Topic  text]  -- some string sent to an app

[Item  text]  -- the item receiving the data

[Data  text]  -- the data being poked

[Result:   integer]  -- DDE  Initiate returns the number of the open channel

Delete: delete an object

Delete  reference  -- the object to delete

[Shift  xlToLeft/xlUp]  -- Move cells up or left when deleting cells

DeleteCustomList: delete a custom list

DeleteCustomList

ListNumber  integer  -- number of the custom list to delete

DeleteNumberFormat: delete an number format from a workbook

DeleteNumberFormat  Workbook  -- the workbook from which the number format will be deleted

NumberFormat  text  -- the number format to delete

DoubleClick: Equivalent to double clicking the active cell or currently selected object

DoubleClick

Duplicate: clone the given object

Duplicate  reference  -- the object to clone

[To  reference]  -- the object to which to move another object

Result:   reference  -- the new object

Edit: Invoke the toolbar button editor

Edit  reference  -- the toolbar button to edit

EditionOptions: Set options to publishers and subscribers in a workbook

EditionOptions  Workbook  -- the workbook for which to set options

type  xlPublisher/xlSubscriber  -- set options for publishers or subscribers

Option  integer  -- the type of information to set

[Name  text]  -- which edition to modify

[Reference  text]  -- the edition reference in R1C1 form

[Appearance  xlScreen/xlPrinter]  -- set appearance as when printed or as on screen

[ChartSize  xlScreen/xlPrinter]  -- how to size a chart

[Format  integer]  -- what format to include in edition

Evaluate: This event passes one or a list of Excel functions and/or macros, which Excel then evaluates and/or executes.

Evaluate  anything  -- Either one function/macro to evaluate/execute, or a list of functions/macros.

Result:   anything  -- If passed one function/macro, Excel returns one value  (the result of evaluating the function or executing the macro statement).  If passed a list, Excel returns the list.

FillAcross: Copy a range of cells to all given sheets

FillAcross  reference  -- the sheets to which to copy the range

RangeToFill  Range  -- a range to copy to all given sheets

[type  xlAll/xlContents/xlFormats]  -- what to copy

FindFile: Bring up Excel's Find File dialog

FindFile

FunctionWizard: Perform a Function Wizard on a cell

FunctionWizard  reference  -- the cell on which to perform the Wizard

Get: Get the data for an object.  Handles extra parameters as a record param

Get  reference  -- The object whose data is to be returned

[As  type class]  -- The desired types for the data, in order of preference

Result:   anything

GetOpenFilename: Displays the Excel Open dialog

GetOpenFilename

[FileFilter  text]  -- File types to display

[FilterIndex  integer]  -- The initial filter to use

[Title  text]  -- Title of dialog

[ButtonText  text]  -- Text to appear in place of 'Open' in the default button

Result:   text  -- the file selected by the user, or false if cancelled

GetSaveAsFilename: Displays the Excel Save As dialog

GetSaveAsFilename

[InitialFileName  text]  -- the suggested file name

[FileFilter  text]  -- File types to display

[FilterIndex  integer]  -- The initial filter to use

[Title  text]  -- Title of dialog

[ButtonText  text]  -- Text to appear in place of 'Open' in the default button

Result:   text  -- the file entered by the user, or false if cancelled

Goto: Selects the given range of VBA procedure

Goto

[Reference  anything]  -- a range object or procedure name to goto

[Scroll  boolean]  -- scroll the new seleciton into view

Group: Group objects or cells together

Group  reference  -- draw objects or field whose values are to be grouped

[Start  fixed]  -- first value to group

[End  fixed]  -- last value to group

[By  fixed]  -- size of the groups

[Periods  boolean]  -- time measurment of the groups

Help: run the Help command for some topic

Help

[topic  integer]  -- topic id for which to bring up help

[using  alias]  -- help file to use

Hide: hide a dialog that was run from a dialog sheet

Hide  reference  -- the dialog sheet whose dialog to hide

[Cancel  boolean]  -- cancel without validating edit fields?

Result:   boolean

Import: load a sound resource from a file

Import  reference  -- the sound note to load from a file

File Name  alias  -- the file from which to load the sound

Resource  anything  -- the name or number of the resource to import

InputBox: Display the Excel input box

InputBox

Prompt  text  -- message to display in dialog

[Title  text]  -- The title of the dialog

[DefaultAnswer  text]  -- The default answer when the dialog is displayed

[Left  integer]  -- Where the left edge of the dialog should be

[Top  integer]  -- Where the top edge of the dialog should be

[HelpFile  alias]  -- The file which contain the help context for this dialog

[HelpContext  integer]  -- The help context id for this dialog

[type  integer]  -- What type of input the dialog should expect

Result:   anything  -- If dialog is canceled return FALSE, else return the value that was entered in the edit box

Insert: Add text to an object

Insert  reference  -- what to insert

[String  text]  -- The text to insert

[File  alias]  -- File to insert as a picture

[Converter  xlBMP/xlWMF/xlWPG/xlDRW/xlDXF/xlHGL/xlCGM/xlEPS/xlTIF/xlPCX/xlPIC/xlPLT/xlPCT]  -- File converter to use when inserting a picture

[Shift  xlToRight/xlDown]  -- Move cells right or down to make room for new cells

InsertFile: Insert a text file into a module

InsertFile  reference  -- the module to insert into

File Name  alias  -- The file to insert

[Merge  boolean]  -- Add the text to existing text or replace all text

LinkCombo: Create a combo item out of a listbox and an edit item

LinkCombo  reference  -- the drawing objects to combo together

[Link  boolean]  -- Whether or not the items are linked together

LinkInfo: Returns information on links

LinkInfo  Workbook  -- the workbook which contains the links

Name  text  -- name of link

LinkInfo  xlUpdateState/xlEditionDate  -- type of information to get

[type  xlOLELinks/Reserved/Reserved/xlPublishers/xlSubscribers]  -- type of link to return

[EditionRef  text]  -- edition reference in R1C1 form

[Result:   integer]  -- automatic or manual update

LinkSources: Return links of the given book

LinkSources  Workbook  -- the workbook which contains the links

[type  xlExcelLinks/xlOLELinks/Reserved/Reserved/xlPublishers/xlSubscribers]  -- type of links to return

[Result:   text]  -- names of links in the given book

LineScroll: provide a way to scroll documents

LineScroll  reference  -- window or pane to scroll

[up  fixed]  -- number of lines to scroll up

[down  fixed]  -- number of lines to scroll down

[left  fixed]  -- number of lines to scroll left

[right  fixed]  -- number of lines to scroll right

ListNames: lists all non-hidden names defined on the worksheet

ListNames  reference  -- the range into which to put the names

Move: Move the object

Move  reference  -- object to move

[To  reference]  -- the object to which to move another object

[Before  anything]  -- a toolbar button index or object

[After  reference]  -- the object after which to move the given object

Merge: merge objects together, like styles

Merge  reference  -- the object that is getting merged (e.g. styles of document 3)

WorkbookToMerge  Workbook  -- the workbook whose styles to merge

[Source  anything]  -- name of or reference to sheet whose scenarios are to be merged

OnKey: Runs a specified macro when a key or key combination is pressed

OnKey

[Key  text]  -- the key or key combination to trap

[RunMacro  text]  -- name of XLM or VBA macro to run

OnRepeat: Runs a specified macro when Edit/Repeat is chosen

OnRepeat

Text  text  -- the text for the Edit/Repeat menu item

RunMacro  text  -- name of XLM or VBA macro to run

OnTime: Runs a specified macro at a particular

OnTime

EarliestTime  text  -- the earliest time at which to run the macro

RunMacro  text  -- name of XLM or VBA macro to run

LatestTime  text  -- the latest time at which to run this macro

Schedule  boolean  -- False means to unschedule this timed macro

OnUndo: Runs a specified macro when Edit/Undo is chosen

OnUndo

Text  text  -- the text for the Edit/Undo menu item

RunMacro  text  -- name of XLM or VBA macro to run

Open: Open an object

Open  reference  -- file to open

[Update  xlExcelLinks/xlOLELinks]  -- update links, default is ask

[ReadOnly  boolean]  -- open file as read-only?

[Format  integer]

[Password  text]  -- the password to unlock a restricted file

[WriteReservedPassword  text]  -- password for read-write access to file

[IgnoreReadOnlyRecommended  boolean]  -- if file is read only recommended, then skip message

[Origin  xlMacintosh/xlWindows/xlMSDOS]  -- where file was created

[Delimiter  text]  -- delimiter character for textfiles

[Editable  boolean]  -- open addin into a visible window

[Notify  boolean]  -- alert user if file can be locked filed becomes writable

[Converter  integer]  -- which file converter to use

OpenLinks: Open the supporting documents of links

OpenLinks  Workbook  -- the workbook which contains the links

Name  text  -- the links whose supporting documents are to be opened

[ReadOnly  boolean]  -- open the documents read only

[type  xlExcelLinks/xlOLELinks/Reserved/Reserved/xlPublishers/xlSubscribers]  -- type of links to return

OpenText: Open an object

OpenText  reference  -- file to open

[Origin  xlMacintosh/xlWindows/xlMSDOS]  -- where file was created

[StartAtRow  integer]  -- row to start importing a text file at

[DataType  xlDelimited/xlFixedWidth]  -- which file converter to use

[TextQualifier  xlDoubleQuote/xlSingleQuote/xlNone]

[TreatConsecutiveDelimitersAsOne  boolean]

[TabDelimiter  boolean]  -- use tab as a delimiter

[SemicolonDelimiter  boolean]  -- use a semicolon as a delimiter

[CommaDelimiter  boolean]  -- use a comma as a delimiter

[SpaceDelimiter  boolean]  -- use a space as a delimiter

[Other  boolean]  -- other character to use as a delimiter

[OtherCharacter  text]

[FieldInfo  integer]  -- a list of tuples

PageScroll: provide a way to scroll documents

PageScroll  reference  -- window or pane to scroll

[up  fixed]  -- number of pages to scroll up

[down  fixed]  -- number of pages to scroll down

[left  fixed]  -- number of pages to scroll left

[right  fixed]  -- number of pages to scroll right

paste: paste to an object

paste  reference  -- where to paste

[Destination  Range]  -- the range to put the clipboard

[Link  boolean]  -- link to source data

[RowCol  xlRows/xlColumns]  -- data is in rows or columns

[SeriesLabels  text]  -- series labels

[CategoryLabels  text]  -- category labels

[Replace  boolean]  -- whether or not to replace data

[NewSeries  boolean]  -- if this is a new series

PasteFace: Paste the face of a toolbar button

PasteFace  reference  -- object to paste

PasteSpecial: paste to an object

PasteSpecial  reference  -- where to paste

[PasteType  xlAll/xlFormulas/xlValues/xlFormats/xlNotes]  -- the type of special paste to do

[Operation  xlNone/xlAdd/xlSubtract/xlMultiply/xlDivide]  -- operation to perform on each pasted cell

[SkipBlanks  boolean]  -- don't paste blank cells

[Transpose  boolean]  -- transpose the range

[Format  text]  -- the clipboard format to paste

[Link  boolean]  -- link to source

[DisplayAsIcon  boolean]

[IconFileName  alias]  -- the file which contains the icon to display

[IconIndex  integer]  -- which icon in the file to use

[IconLabel  text]  -- text label for the icon

Result:   Range  -- the actual range that got pasted

PivotTableWizard: Perform a Pivot Table Wizard

PivotTableWizard  reference  -- the worksheet on which to perform the Wizard

[SourceType  xlDatabase/xlExternal/xlConsolidation/xlPivotTable]  -- the type of data to use for the pivot table

[SourceData  text]

[Destination  reference]  -- the cell to create the pivot table

[TableName  text]  -- name of pivot table to create or modify

[RowGrand  boolean]  -- show grand totals?

[ColumnGrand  boolean]  -- show grand totals?

[SaveData  boolean]  -- save data with view?

[HasAutoFormat  boolean]  -- autoformat the pivot table?

[AutoPage  boolean]  -- create a page field if source is consolidation

Play: play a sound or movie or something

Play  reference  -- the object to play (e.g. sound note of cell 'r2c2')

Print: Print object(s)

Print  reference  -- the object to print

[Preview  boolean]  -- whether to preview instead of print

[FromPage  integer]  -- the first page to print

[ToPage  integer]  -- the last page to print

[Copies  integer]  -- the number of copies to print

PrintPreview: Preview an object

PrintPreview  reference  -- the object to print

Protect: turn protection on for sheets and documents

Protect  reference  -- the object to protect

[Password  text]  -- the password to access the protected items

[DrawObjects  boolean]  -- protect draw objects?

[Contents  boolean]  -- protect sheet contents?

[Scenarios  boolean]  -- protect scenarios?

[Structure  boolean]  -- protect workbook structure?

[Windows  boolean]  -- protect windows?

Recalculate: Forces a recalculation of all sheets.  This is useful if the recalculation mode of the application has been set to manual.

Recalculate  reference  -- the object (i.e. range or document) to recalc, if missing then recalc everything

Record: record a sound

Record  reference  -- the object to record

RecordMacro: Record text into a VBA or XLM macro

RecordMacro

[BasicCode  text]  -- a line of Basic code to record, if currently recording Basic

[XLMCode  text]  -- a line of XLM to record if currently recording XLM

RefreshTable: Refreshes pivot table with lastest data from source

RefreshTable  reference  -- the pivot table to refresh

Result:   boolean  -- success or not

RegisterXLL: Load an XLL code resource and register it

RegisterXLL

Name  alias  -- the file to load

Result:   boolean  -- Whether the file was loaded and registered successfully

RemoveAllItems: Remove all items from a listbox

RemoveAllItems  reference  -- the listbox from which to remove all itmes

RemoveItems: Remove some items from a listbox

RemoveItems  reference  -- the listbox from which to remove all itmes

Index  integer  -- the first item to remove

[Count  integer]  -- the number of items to remove

RepeatCommand: Repeats the last user interface command

RepeatCommand

Reset: Restores an object to it's default state

Reset  reference  -- the object to restore to original state

ResetTipWizard: Resets the Tip Wizard so that all tips will be shown

ResetTipWizard

Reshape: Reshape a drawing by inserting, deleting or moving a vertex

Reshape  reference  -- the drawing to reshape

Vertex  integer  -- index of vertex to insert, delete of move

Insert  boolean  -- insert a vew vertex?  If false and Left and Top are omitted, then delete

Left  fixed  -- horizontal coordinate to move or insert vertex

Top  fixed  -- vertical coordinate to move or insert vertex

RunAutoMacros: Run some auto macros on a given workbook

RunAutoMacros  Workbook  -- the workbook whose auto macros to run

Which  xlAutoOpen/xlAutoClose/xlAutoActivate/xlAutoDeactivate  -- which auto macros to run

Save: Save an object

Save  reference  -- the object to save

[In  alias]  -- file in which to save

[As  xlNormal/xlSYLK/xlText/xlWKS/xlWK1/xlCSV/xlDBF2/xlDBF3/xlDIF /Reserved/xlDBF4/Reserved/Reserved/xlWJ2WD1/xlWK3/xlExcel2 /xlTemplate/xlAddIn/xlTextMac/xlTextWindows/xlTextMSDOS/xlCSVMac /xlCSVWindows/xlCSVMSDOS/xlIntlMacro/xlIntlAddIn/xlExcel2FarEast/...]  -- file type to save

[Password  text]  -- string to protect the file by

[WriteReservedPassword  text]  -- password for read-write access to file

[ReadOnlyRecommended  boolean]  -- when opening this file, Excel will suggest read only

[CreateBackup  boolean]  -- create a backup of this file

SaveCopy: Save a copy of an object

SaveCopy  reference  -- the object to save

[In  alias]  -- file in which to save

Select: Select the object

Select  reference  -- object to select

[Replace  boolean]  -- replace current selection, or extend it

ScrollWorkbookTabs: Scroll the workbook tabs of the given window

ScrollWorkbookTabs  Window  -- window whose tabs to scroll

[Sheets  integer]  -- the number of sheet tabs to scroll

[Position  xlFirst/xlLast]  -- scroll to beginning or end

SetInfoDisplay: Set the information to display in the info window

SetInfoDisplay  Window  -- the info window

[Cell  boolean]  -- display cell

[Formula  boolean]  -- display formula

[Value  boolean]  -- display Value

[Format  boolean]  -- display format

[Protection  boolean]  -- display protection

[Names  boolean]  -- display names

[Precedents  xlNone/xlDirect/xlAll]  -- display precedents

[Dependents  xlNone/xlDirect/xlAll]  -- display dependents

[Note  boolean]  -- display note

SetLinkOnData: Set a macro to run whenever a link is updated

SetLinkOnData  Workbook  -- the workbook which contains the link

Name  text  -- name of link

[RunMacro  text]  -- name of XLM or VBA macro to run

Show: make something visible

Show  reference  -- the object to be made visible

ShowAllData: shows all data in a filtered list

ShowAllData  reference  -- The worksheet whose filtered data will be shown

ShowDataForm: Show The data form associated with the given sheet

ShowDataForm  reference  -- the worksheet whose data form will be displayed

ShowLevels: display outline levels

ShowLevels  reference  -- the outline

[RowLevels  integer]  -- how many row levels to display

[ColumnLevels  integer]  -- how many column levels to display

ShowPages: Does pivot table stuff

ShowPages  reference  -- the pivot table to create pages for

PageField  text  -- the page field to vary from ply to ply

Result:   boolean  -- success or not

SpellCheck: Check the spelling of a word

SpellCheck  reference  -- document or range or text box etc to spell check

[word  text]  -- Word to be checked for spelling

[UsingDictionary  alias]  -- file to be used as a custom dictionary

[IgnoreUppercase  boolean]  -- Ignore words in all uppercase

[AlwaysSuggest  boolean]  -- always suggest alternative spellings

Result:   boolean  -- True if spelling correct

SubscribeTo: Subscribes to an edition

SubscribeTo  reference  -- the range doing the subscribing

[Edition  alias]  -- the edition to which to subscribe

[Format  xlPicture/xlText]  -- picture or text

Result:   reference  -- the new subscriber

Undo: Undoes the last user interface command

Undo

Ungroup: Ungroup pivottable selection

Ungroup  reference  -- range to be ungrouped

Unprotect: turn protection off for sheets and documents

Unprotect  reference  -- the object to protect

[Password  text]  -- the password to access the protected items

Update: tell some object to update itself

Update  reference  -- the object to update itself

UpdateFromFile: if the file on disk is more up-to-date than the given workbook, update the workbook

UpdateFromFile  Workbook  -- the workbook to update

UpdateLink: Updates an Excel, DDE or OLE link

UpdateLink  Workbook  -- the workbook which contains the link to update

[Name  text]  -- the name of the link to update

[Type  xlExcelLinks/xlOLELinks]  -- the type of link to update

Verb: tell an OLE object to do something

Verb  reference  -- the object to do something

[Verb  xlPrimary/xlOpen]  -- the action to perform

class info: Get information about an object class

class info  type class  -- the object class about which information is requested

[in  writing code]  -- the human language and script system in which to return information

Result:   type class info  -- a record containing the objectÕs properties and elements

close: Close an object

close  reference  -- the object to close

[saving  ///Save objects now/Do not save objects/Ask the user whether to save]  -- specifies whether changes should be saved before closing

[saving in  alias]  -- the file in which to save the object

count: Return the number of elements of a particular class within an object

count  reference  -- the object whose elements are to be counted

each  type class  -- the class of the elements to be counted.

Result:   integer  -- the number of elements

data size: Return the size in bytes of an object

data size  reference  -- the object whose data size is to be returned

[as  type class]  -- the data type for which the size is calculated

Result:   integer  -- the size of the object in bytes

delete: Delete an element from an object

delete  reference  -- the element to delete

duplicate: Duplicate object(s)

duplicate  reference  -- the object(s) to duplicate

[to  location reference]  -- the new location for the object(s)

Result:   reference  -- to the duplicated object(s)

event info: Get information about the Apple events in a suite

event info  type class  -- the event class of the Apple events for which to return information

[in  writing code]  -- the human language and script system in which to return information

Result:   type event info  -- a record containing the events and their parameters

exists: Verify if an object exists

exists  reference  -- the object in question

Result:   boolean  -- true if it exists, false if not

make: Make a new element

make

new  type class  -- the class of the new element.

at  location reference  -- the location at which to insert the element

[with data  anything]  -- the initial data for the element

[with properties  record]  -- the initial values for the properties of the element

Result:   reference  -- to the new object(s)

move: Move object(s) to a new location

move  reference  -- the object(s) to move

to  location reference  -- the new location for the object(s)

Result:   reference  -- to the object(s) after they have been moved

open: Open the specified object(s)

open  reference  -- list of objects to open

print: Print the specified object(s)

print  reference  -- list of objects to print

quit: Quit an application program

quit

[saving  ///Save objects now/Do not save objects/Ask the user whether to save]  -- specifies whether to save currently open documents

save: Save an object

save  reference  -- the object to save

[in  alias]  -- the file in which to save the object

[as  type class]  -- the file type of the document in which to save the data

suite info: Get information about event suite(s)

suite info  type class  -- the suite for which to return information

[in  writing code]  -- the human language and script system in which to return information

Result:   type suite info  -- a record containing the suites and their versions

Class Root: Inherited by all objects

Properties:

Parent  anything  [r/o]

Class _Global:

Properties:

ActiveCell  Range  [r/o]

ActiveChart  Sheet  [r/o]

ActiveMenubar  MenuBar  [r/o]

ActivePrinter  text

ActiveSheet  Sheet  [r/o]

ActiveWindow  Window  [r/o]

ActiveWorkbook  Workbook  [r/o]

DDEAppReturnCode  boolean  [r/o]

Selection  anything

Class Application: Microsoft Excel Application

Plural form:

applications

Elements:

Window by numeric index, by name

Workbook by numeric index, by name

Document by numeric index, by name

Worksheet by numeric index, by name

Sheet by numeric index, by name

Chart by numeric index, by name

Module by numeric index, by name

DialogSheet by numeric index, by name

Excel4MacroSheet by numeric index, by name

Excel4IntlMacroSheet by numeric index, by name

Range by name

Cell by numeric index, by name

Row by numeric index

Column by numeric index, by name

Style by numeric index, by name

Toolbar by numeric index, by name

AddIn by name

Dialog by numeric index

MenuBar by numeric index

ShortcutMenu by numeric index

Name by numeric index, by name

Properties:

AlertBeforeOverwriting  boolean

AlternateStartupPath  text

AskToUpdateLinks  boolean

Build  integer  [r/o]

CalculateBeforeSave  boolean

Calculation  xlAutomatic/xlSemiautomatic/xlManual

CanPlaySounds  boolean  [r/o]

CanRecordSounds  boolean  [r/o]

Caption  text

CellDragandDrop  boolean

Clipboard  anything  [r/o]  -- the clipboard

ClipboardFormats  integer  [r/o]

ColorButtons  boolean

CommandUnderlines  xlOn/xlOff/xlAutomatic

ConstrainNumeric  boolean

CopyObjectsWithCells  boolean

CustomListCount  integer  [r/o]

CutOrCopyMode  xlCopy/xlCut

DDEAppReturnCode  boolean  [r/o]

DataEntryMode  xlOff/xlOn/xlStrict

DefaultFilePath  text

DisplayAlerts  boolean

DisplayClipboardWindow  boolean

DisplayExcel4Menus  boolean

DisplayFormulaBar  boolean

DisplayFullScreen  boolean

DisplayInfoWindow  boolean

DisplayNoteIndicator  boolean

DisplayRecentFiles  boolean

DisplayScrollBars  boolean

DisplayStatusBar  boolean

EditDirectlyInCell  boolean

EnableCancelKey  xlDisabled/xlInterrupt/xlErrorHandler

EnableTipWizard  boolean

FileConverters  text  [r/o]

FixedDecimal  boolean

FixedDecimalPlaces  integer

Height  fixed

IgnoreRemoteRequests  boolean

Interactive  boolean

International  anything  [r/o]

IsFrontProcess  boolean  [r/o]  -- Is this the frontmost application?

Iteration  boolean

LargeButtons  boolean

LibraryPath  text  [r/o]

Lotus123Help  boolean

MailSession  text  [r/o]

MailSystem  xlNoMailSystem/xlMAPI/xlPowerTalk  [r/o]

MathCoprocessorAvailable  boolean

MaxChange  integer

MaximumIterations  integer

MemoryFree  integer  [r/o]

MemoryTotal  integer  [r/o]

MemoryUsed  integer  [r/o]

MouseAvailable  boolean  [r/o]

MoveAfterReturn  boolean

Name  text  [r/o]  -- the name

OnCalculate  text

OnData  text

OnDoubleClick  text

OnEntry  text

OnSheetActivate  text

OnSheetDeactivate  text

OnWindow  text

OperatingSystem  text  [r/o]

OrganizationName  text  [r/o]

Path  text  [r/o]

PathSeparator  text  [r/o]

PreviousSelections  Range  [r/o]

PromptForSummaryInfo  boolean

RecordRelative  boolean  [r/o]

ReferenceStyle  xlA1/xlR1C1

RegisteredFunctions  text  [r/o]

ScreenUpdating  boolean

Selection  anything  -- the selection visible to the user

SheetsInNewWorkbook  integer

ShowToolTips  boolean

StandardFontName  text  [r/o]

StandardFontSize  integer  [r/o]

StartupPath  text  [r/o]

StatusBar  text

TextItemDelimiter  text  [r/o]

TransitionMenuKey  text

TransitionNavigationKeys  boolean

UsableHeight  integer  [r/o]

UsableWidth  integer  [r/o]

UserName  text  [r/o]

UserSelection  anything  [r/o]

Value  text  [r/o]

Version  integer  [r/o]  -- the version of the application

Visible  boolean

Width  integer

WindowState  xlNormal/xlMinimized/xlMaximized

WindowsForPens  boolean  [r/o]

Class Style: A Style

Plural form:

Styles

Elements:

Border by numeric index

Properties:

AddIndent  boolean

Font  Font

FormulaHidden  boolean

HorizontalAlignment  xlGeneral/xlLeft/xlCenter/xlRight/xlFill/xlJustify/xlCenterAcrossSelection/xlDistributed

IncludeAlignment  boolean

IncludeBorder  boolean

IncludeFont  boolean

IncludeNumberformat  boolean

IncludePattern  boolean

IncludeProtection  boolean

Interior  Interior  [r/o]

Name  text

NameLocal  text

NumberFormat  text

NumberFormatLocal  text

Orientation  xlHorizontal/xlVertical/xlUpward/xlDownward

Protection  xlReadWrite/xlReadOnly

Value  boolean

VerticalAlignment  xlTop/xlCenter/xlBottom/xlJustify/xlDistributed

WrapText  boolean

Class Toolbar: A Toolbar

Plural form:

Toolbars

Elements:

ToolbarButton by numeric index

Properties:

Builtin  boolean  [r/o]

Height  fixed  [r/o]

Left  fixed

Name  text  [r/o]

Position  xlTop/xlLeft/xlRight/xlBottom/xlFloating

Top  fixed

Visible  boolean

Width  integer

Class ToolbarButton: A button

Plural form:

ToolbarButtons

Properties:

Builtin  boolean  [r/o]

Builtinface  boolean

Enabled  boolean

Hasgap  integer

Id  integer  [r/o]

Name  text  [r/o]

OnAction  text

Parent  anything  [r/o]

Pushed  boolean

Width  integer

Class AddIn: An Add In Macro

Plural form:

AddIns

Properties:

Author  boolean  [r/o]

Comments  boolean  [r/o]

FullName  text  [r/o]

Installed  boolean

Keywords  boolean  [r/o]

Name  text  [r/o]

Path  text  [r/o]

Subject  boolean  [r/o]

Title  text  [r/o]

Class Workbook: A single Workbook

Plural form:

Workbooks

Elements:

Window by numeric index, by name

Worksheet by numeric index, by name

Sheet by numeric index, by name

Chart by numeric index, by name

Module by numeric index, by name

DialogSheet by numeric index, by name

Excel4MacroSheet by numeric index, by name

Excel4IntlMacroSheet by numeric index, by name

Style by numeric index, by name

Name by numeric index, by name

Properties:

ActiveChart  Sheet  [r/o]

ActiveSheet  Sheet  [r/o]

Author  text

Colors  integer  [r/o]

Comments  text

CreateBackup  boolean  [r/o]

Date1904  boolean

DisplayDrawingObjects  xlAll/xlPlaceholders/xlHide

FileFormat  xlNormal/xlSYLK/xlText/xlWKS/xlWK1/xlCSV/xlDBF2/xlDBF3/xlDIF/Reserved/xlDBF4 /Reserved/Reserved/xlWJ2WD1/xlWK3/xlExcel2/xlTemplate/xlAddIn/xlTextMac /xlTextWindows/xlTextMSDOS/xlCSVMac/xlCSVWindows/xlCSVMSDOS/xlIntlMacro /xlIntlAddIn/xlExcel2FarEast/...  [r/o]

FullName  text  [r/o]

HasMailer  boolean

HasPassword  boolean  [r/o]

HasRoutingSlip  boolean

Keywords  text

Mailer  Mailer  [r/o]

Name  text  [r/o]

OnSheetActivate  text

OnSheetDeactivate  text

Path  text  [r/o]

PrecisionAsdisplayed  boolean

ProtectStructure  boolean

ProtectWindows  boolean

ReadOnly  boolean  [r/o]

ReadOnlyRecommended  boolean  [r/o]

Routed  boolean  [r/o]

RoutingSlip  RoutingSlip  [r/o]

SaveLinkValues  boolean

Saved  boolean  [r/o]

Subject  text

Title  text

UpdateRemoteReferences  boolean

WriteReserved  text  [r/o]

WriteReservedBy  text  [r/o]

Class Document: A document

Plural form:

Documents

Properties:

Cell Protection  xlReadWrite/xlReadOnly

Modified  boolean  [r/o]  -- Has the document been modified since the last save?

Name  text  [r/o]

Number of Windows  integer  [r/o]

Object Protection  xlReadWrite/xlReadOnly

Pathname  text  [r/o]

Protection  xlReadWrite/xlReadOnly  [r/o]

Selection  anything

Type  xlWorksheet/xlExcel4MacroSheet/xlChart/xlWorkbook/xlClipboard/xlInfo  [r/o]

Class Sheet: A Sheet in a workbook

Plural form:

Sheets

Elements:

Sheet before/after another element

Properties:

Index  integer  [r/o]

Name  text

Next  Sheet  [r/o]

OnDoubleClick  text

OnSheetActivate  text

OnSheetDeactivate  text

PageSetup  PageSetup  [r/o]

Parent  anything  [r/o]

Previous  Sheet  [r/o]

ProtectContents  boolean  [r/o]

ProtectDrawingObjects  boolean  [r/o]

ProtectScenarios  boolean  [r/o]

Visible  xlVeryHidden

Class Worksheet: A worksheet

Plural form:

Worksheets

Elements:

Cell by numeric index, by name

Row by numeric index

Column by numeric index, by name

Range by name

PivotTable by numeric index, by name

Scenario by numeric index, by name

DrawingObject by numeric index, by name

GroupObject by numeric index, by name

Line by numeric index, by name

Rectangle by numeric index, by name

Oval by numeric index, by name

Arc by numeric index, by name

OLEObject by numeric index, by name

TextBox by numeric index, by name

Picture by numeric index, by name

ChartObject by numeric index, by name

Drawing by numeric index, by name

Button by numeric index, by name

CheckBox by numeric index, by name

OptionButton by numeric index, by name

ScrollBar by numeric index, by name

ListBox by numeric index, by name

GroupBox by numeric index, by name

DropDown by numeric index, by name

Spinner by numeric index, by name

Label by numeric index, by name

EditBox by numeric index, by name

Properties:

AutoFilterMode  boolean  [r/o]

CircularReference  Range  [r/o]

ConsolidationFunction  xlAverage/xlCountNums/xlCount/xlMax/xlMin/xlProduct/xlStDev/xlStDevP/xlSum/xlVar/xlVarP  [r/o]

ConsolidationOptions  Range  [r/o]

ConsolidationSources  Range  [r/o]

DisplayAutomaticPageBreaks  boolean

FilterMode  boolean  [r/o]

OnCalculate  text

OnData  text

OnEntry  text

Outline  Outline  [r/o]

RangeUsed  Range  [r/o]

StandardHeight  integer  [r/o]

StandardWidth  integer

TransitionExpressionEvaluation  boolean

TransitionFormulaEntry  boolean

Type  xlWorksheet/Reserved/xlExcel4MacroSheet/xlExcel4IntlMacroSheet  [r/o]

Class Excel4MacroSheet: Excel 4.0 Macro Sheet

Plural form:

Excel4MacroSheets

Class Excel4IntlMacroSheet: Excel 4.0 International Macro Sheet

Plural form:

Excel4IntlMacroSheets

Class PivotTable: A PivotTable

Plural form:

PivotTables

Elements:

PivotField by numeric index, by name

Properties:

ColumnFields  PivotField  [r/o]

ColumnGrand  boolean

ColumnRange  Range  [r/o]

DataBodyRange  Range  [r/o]

DataFields  PivotField  [r/o]

DataLabelRange  Range  [r/o]

HasAutoFormat  boolean

HiddenFields  PivotField  [r/o]

InnerDetail  text

Name  text

PageFields  PivotField  [r/o]

PageRange  Range  [r/o]

Parent  anything  [r/o]

RefreshDate  integer  [r/o]

RefreshName  text  [r/o]

RowFields  PivotField  [r/o]

RowGrand  boolean

RowRange  Range  [r/o]

SaveData  boolean

SourceData  text  [r/o]

TableRange1  Range  [r/o]

TableRange2  Range  [r/o]

Value  text

VisibleFields  PivotField  [r/o]

Class PivotField: A PivotTable Field

Plural form:

PivotFields

Elements:

PivotItem by numeric index, by name

Properties:

BaseField  PivotField

BaseItem  PivotItem

Calculation  xlNormal/xlDifferenceFrom/xlPercentOf/xlPercentDifferenceFrom/xlRunningTotal/xlPercentOfRow/xlPercentOfColumn/xlPercentOfTotal/xlIndex

ChildField  PivotField  [r/o]

ChildItems  PivotItem  [r/o]

CurrentPage  boolean

DataRange  Range  [r/o]

DataType  xlText/xlNumber/xlDate  [r/o]

Function  xlSum/xlCountNums/xlAverage/xlMax/xlMin/xlProduct/xlCount/xlStDev/xlStDevP/xlVar/xlVarP

GroupLevel  integer  [r/o]

HiddenItems  PivotItem  [r/o]

LabelRange  Range  [r/o]

Name  text

NumberFormat  text

Orientation  xlHidden/xlRowField/xlColumnField/xlPageField/xlDataField

Parent  anything  [r/o]

ParentField  PivotField  [r/o]

ParentItems  PivotItem  [r/o]

Position  integer

SourceName  text  [r/o]

Subtotals  integer

TotalLevels  integer  [r/o]

Value  text

VisibleItems  PivotItem  [r/o]

Class PivotItem: A PivotTable PivotField PivotItem

Plural form:

PivotItems

Properties:

ChildItems  PivotItem  [r/o]

DataRange  Range  [r/o]

LabelRange  Range  [r/o]

Name  text

Parent  anything  [r/o]

ParentItem  PivotItem  [r/o]

ParentShowDetail  boolean  [r/o]

Position  integer

ShowDetail  boolean

SourceName  text  [r/o]

Value  text

Visible  boolean

Class Scenario: An individual scenario

Plural form:

Scenarios

Properties:

ChangingCells  Range  [r/o]

Hidden  boolean

Index  integer

Name  text  [r/o]

Parent  anything  [r/o]

Protection  xlReadWrite/xlReadOnly

Scenariocomment  text  [r/o]

Values  'YYYY'  [r/o]

Class MenuBar: A menu bar

Plural form:

MenuBars

Elements:

Menu by numeric index, by name

Properties:

Caption  text

Index  xlWorksheet4/xlChart4/xlNoDocuments/xlInfo/xlWorksheetShort/xlChartShort/xlWorksheet/xlChart/xlModule

Parent  anything  [r/o]

Class Menu: A menu

Plural form:

Menus

Elements:

MenuItem by numeric index, by name

Properties:

Caption  text

Enabled  boolean

Index  integer

Parent  anything  [r/o]

Class ShortcutMenu:

Class MenuItem: A menu item

Plural form:

MenuItems

Properties:

Caption  text

Checked  boolean

Enabled  boolean

Index  integer

OnAction  text

Parent  anything  [r/o]

StatusBar  'Lctx'

Class Window: A single Window

Plural form:

Windows

Elements:

Pane by numeric index

Properties:

ActiveCell  Range

ActiveChart  Sheet  [r/o]

ActivePane  Pane

ActiveSheet  Sheet  [r/o]

Caption  text

DisplayBookTabs  boolean

DisplayFormulas  boolean

DisplayGridlines  boolean

DisplayHeadings  boolean

DisplayHorizontalScrollBar  boolean

DisplayOutline  boolean

DisplayRightToLeft  boolean

DisplayVerticalScrollBar  boolean

DisplayZeros  boolean

FreezePanes  boolean

GridlineColor  RGB color

GridlineColorIndex  xlAutomatic

HasTitleBar  boolean  [r/o]  -- Does the window have a title bar?

Height  fixed

Index  integer  [r/o]  -- the number of the window

Index  anything  [r/o]

IsFloating  boolean  [r/o]  -- Does the window float?

IsModal  boolean  [r/o]  -- Is the window modal?

IsResizable  boolean  [r/o]  -- Is the window resizable?

IsVisible  boolean  [r/o]  -- Is the window visible?

IsZoomed  boolean  [r/o]  -- Is the window zoomed?

Left  fixed

Name  text  [r/o]

OnWindow  text

PageSetup  PageSetup  [r/o]

Parent  anything  [r/o]

ScrollColumn  integer

ScrollRow  integer

SelectedSheets  anything

Selection  anything

Split  boolean

SplitColumn  fixed

SplitHorizontal  integer

SplitRow  fixed

SplitVertical  integer

TabRatio  fixed

Top  fixed

Type  xlWorkbook/xlInfo/xlClipboard/xlChartInPlace/xlChartAsWindow  [r/o]

UsableHeight  integer  [r/o]

UsableWidth  integer  [r/o]

Visible  boolean

VisibleRange  Range  [r/o]

Width  fixed

WindowNumber  integer  [r/o]

WindowState  xlMinimized/xlMaximized/xlNormal

Zoom  integer

bounds  bounding rectangle  -- the boundary rectangle for the window

closeable  boolean  [r/o]  -- Does the window have a close box?

zoomable  boolean  [r/o]  -- Is the window zoomable?

Class Pane: A Pane of a Window

Plural form:

Panes

Properties:

Index  integer  [r/o]

Parent  anything  [r/o]

ScrollColumn  integer

ScrollRow  integer

VisibleRange  Range

Class Name:

Plural form:

Names

Properties:

Category  text

CategoryLocal  text

Index  integer  [r/o]

MacroType  xlFunction/xlCommand/xlNone

Name  text

NameLocal  text

Parent  anything  [r/o]

RefersTo  text

RefersToLocal  text

RefersToR1C1  text

RefersToR1C1Local  text

ShortCutKey  text

Value  text

Visible  boolean

Class Graphic Object:

Properties:

BottomRightCell  Range  [r/o]

Enabled  boolean

Height  integer

Index  integer  [r/o]

Left  fixed

Name  text

OnAction  text

Parent  anything  [r/o]

Placement  xlMoveAndSize/xlMove/xlFreeFloating

PrintObject  boolean

Protection  xlReadWrite/xlReadOnly

Top  fixed  [r/o]

TopLeftCell  Range  [r/o]

Visible  boolean

Width  fixed  [r/o]

ZOrder  integer  [r/o]

Class DrawingObject: An Individual Drawing Object

Plural form:

DrawingObjects

Elements:

Characters as a range of elements

Properties:

Accelerator  text

AddIndent  boolean

ArrowheadLength  xlShort/xlMedium/xlLong

ArrowheadStyle  xlNone/xlOpen/xlClosed/xlDoubleOpen/xlDoubleClosed

ArrowheadWidth  xlNarrow/xlMedium/xlWide

AutoSize  boolean

Border  Border  [r/o]

CancelButton  boolean

Caption  text

DefaultButton  boolean

DismissButton  boolean

Display3DShading  boolean

DisplayVerticalScrollBar  boolean

DropDownLines  integer

Font  Font  [r/o]

Formula  text

HelpButton  boolean

HorizontalAlignment  xlLeft/xlCenter/xlRight/xlJustify/xlDistributed

InputType  integer

Interior  Interior  [r/o]

ItemList  text

LargeChange  integer

LinkedCell  text

LinkedObject  text

ListCount  integer

ListFillRange  text

ListIndex  integer

LockedText  xlReadWrite/xlReadOnly

Max  integer

Min  integer

MultiLine  boolean

MultiSelect  xlNone/xlSimple/xlExtended

Orientation  xlHorizontal/xlVertical/xlUpward/xlDownward

PhoneticAccelerator  text

RoundedCorners  boolean

Selected  boolean

Shadow  boolean

SmallChange  integer

Text  text

Value  integer

VerticalAlignment  xlTop/xlCenter/xlBottom/xlJustify/xlDistributed

Vertices  integer  [r/o]

Class Graphic Shape:

Properties:

Border  Border  [r/o]

Interior  Interior  [r/o]

Shadow  boolean

Class Graphic Text Root:

Elements:

Characters as a range of elements

Properties:

Caption  text

LockedText  xlReadWrite/xlReadOnly

Text  text

Class Graphic Rich Text Root:

Elements:

Characters as a range of elements

Properties:

AddIndent  boolean

AutoSize  boolean

Caption  text

Font  Font

Formula  text

HorizontalAlignment  xlLeft/xlCenter/xlRight/xlJustify/xlDistributed

LockedText  xlReadWrite/xlReadOnly

Orientation  xlHorizontal/xlVertical/xlUpward/xlDownward

Text  text

VerticalAlignment  xlTop/xlCenter/xlBottom/xlJustify/xlDistributed

Class GroupObject: An Individual Group Object

Plural form:

GroupObjects

Class Line: An Individual Line Object

Properties:

ArrowheadLength  xlShort/xlMedium/xlLong

ArrowheadStyle  xlNone/xlOpen/xlClosed/xlDoubleOpen/xlDoubleClosed

ArrowheadWidth  xlNarrow/xlMedium/xlWide

Border  Border  [r/o]

Class Lines: A Collection of Line Objects

Elements:

Line by numeric index, by name

Properties:

X1  integer

X2  integer

Y1  integer

Y2  integer

Class Rectangle: An Individual Rectangle Object

Plural form:

Rectangles

Properties:

RoundedCorners  boolean

Class Oval: An Individual Oval Object

Plural form:

Ovals

Class Arc: An Individual Arc Object

Class Arcs: A Collection of Arc Objects

Elements:

Arc by numeric index, by name

Properties:

X1  integer

X2  integer

Y1  integer

Y2  integer

Class TextBox: An Individual Text Box Object

Plural form:

TextBoxes

Elements:

Characters as a range of elements

Properties:

Border  Border  [r/o]

Interior  Interior  [r/o]

RoundedCorners  boolean

Shadow  boolean

Class Picture: An Individual Picture Object

Plural form:

Pictures

Properties:

Formula  text

Class OLEObject: An Individual OLE Object

Plural form:

OLEObjects

Properties:

AutoObject  reference  [r/o]

AutoUpdate  boolean  [r/o]

OLEType  xlOLELink/xlOLEEmbed  [r/o]

Class ChartObject: An Individual Embedded Chart Object

Plural form:

ChartObjects

Properties:

Chart  Chart  [r/o]

Class Drawing: An Individual Freehand or Polygon Object

Properties:

Vertices  integer  [r/o]

Class Drawings: A Collection of Freehand or Polygon Objects

Elements:

Drawing by numeric index, by name

Properties:

Closed  boolean

X1  integer

X2  integer

Y1  integer

Y2  integer

Class Button: An Individual Button Object

Plural form:

Buttons

Elements:

Characters as a range of elements

Properties:

Accelerator  text

CancelButton  boolean

DefaultButton  boolean

DismissButton  boolean

HelpButton  boolean

PhoneticAccelerator  text

Class EditBox: An Individual Edit Box Object

Plural form:

EditBoxes

Elements:

Characters as a range of elements

Properties:

Caption  text

DisplayVerticalScrollBar  boolean

InputType  xlText/xlInteger/xlNumber/xlReference/xlFormula

LinkedObject  text

MultiLine  boolean

Text  text

Class CheckBox: An Individual CheckBox Object

Plural form:

CheckBoxes

Elements:

Characters as a range of elements

Properties:

Accelerator  text

Border  Border  [r/o]

Display3DShading  boolean

Interior  Interior  [r/o]

LinkedCell  text

PhoneticAccelerator  text

Value  xlOff/xlOn/xlMixed

Class OptionButton: An Individual Option Button Object

Plural form:

OptionButtons

Elements:

Characters as a range of elements

Class Spinner: An Individual Spinner Object

Plural form:

Spinners

Properties:

Display3DShading  boolean

LinkedCell  text

Max  integer

Min  integer

SmallChange  integer

Value  integer

Class ScrollBar: An Individual Scrollbar Object

Plural form:

ScrollBars

Properties:

LargeChange  integer

Class ListBox: An Individual ListBox Object

Plural form:

ListBoxes

Properties:

Display3DShading  boolean

ItemList  text

LinkedCell  text

LinkedObject  text

ListCount  integer

ListFillRange  text

ListIndex  integer

MultiSelect  xlNone/xlSimple/xlExtended

Selected  boolean

Value  integer

Class GroupBox: An Individual GroupBox Object

Plural form:

GroupBoxes

Elements:

Characters as a range of elements

Properties:

Accelerator  text

Display3DShading  boolean

PhoneticAccelerator  text

Class DropDown: An Individual DropDown Object

Elements:

Characters as a range of elements

Properties:

Caption  text

DropDownLines  integer

Text  text

Class DropDowns: A Collection of DropDown Objects

Elements:

DropDown by numeric index, by name

Properties:

Editable  boolean

Class DialogFrame: An Individual Dialog Frame Object

Elements:

Characters as a range of elements

Properties:

Caption  text

Class Label: An Individual Label Object

Plural form:

Labels

Elements:

Characters as a range of elements

Class Interior: Interior of a cell or drawing object

Properties:

Color  RGB color

ColorIndex  xlAutomatic/xlNone

Pattern  xlAutomatic/xlNone/xlSolid/xlGray50/xlGray75/xlGray25/xlHorizontal/xlVertical/xlDown/xlUp/xlChecker/xlSemiGray75/xlLightHorizontal/xlLightVertical/xlLightDown/xlLightUp/xlGrid/xlCrissCross/xlGray16/xlGray8

PatternColor  RGB color

PatternColorIndex  xlAutomatic/xlNone

Class SoundNote: A sound note in a cell

Properties:

Parent  Range  [r/o]

Class Characters: Characters of a cell or drawing object

Properties:

Caption  text

Font  Font  [r/o]

Parent  anything  [r/o]

Text  text

Class Dialog:

Plural form:

Dialogs

Class Outline: An Outline

Properties:

AutomaticStyles  boolean

Parent  anything  [r/o]

SummaryColumn  xlLeft/xlRight

SummaryRow  xlAbove/xlBelow

Class Module: Basic Module

Plural form:

Modules

Class DialogSheet: Dialog Sheet

Plural form:

DialogSheets

Elements:

DrawingObject by numeric index, by name

GroupObject by numeric index, by name

Line by numeric index, by name

Rectangle by numeric index, by name

Oval by numeric index, by name

Arc by numeric index, by name

OLEObject by numeric index, by name

TextBox by numeric index, by name

Picture by numeric index, by name

ChartObject by numeric index, by name

Drawing by numeric index, by name

Button by numeric index, by name

CheckBox by numeric index, by name

OptionButton by numeric index, by name

ScrollBar by numeric index, by name

ListBox by numeric index, by name

GroupBox by numeric index, by name

DropDown by numeric index, by name

Spinner by numeric index, by name

Label by numeric index, by name

EditBox by numeric index, by name

Properties:

DefaultButton  text

DialogFrame  DialogFrame  [r/o]

Focus  text

Class PageSetup: PageSetup Class

Properties:

BlackAndWhite  boolean

BottomMargin  fixed

CenterFooter  text

CenterHeader  text

CenterHorizontally  boolean

CenterVertically  boolean

ChartSize  xlScreenSize/xlFitToPage/xlFullPage

Draft  boolean

FirstPageNumber  xlAutomatic

FitToPagesTall  boolean

FitToPagesWide  boolean

FooterMargin  fixed

HeaderMargin  fixed

LeftFooter  text

LeftHeader  text

LeftMargin  fixed

Order  xlDownThenOver/xlOverThenDown

Orientation  xlPortrait/xlLandscape

PaperSize  integer

Parent  anything

PrintArea  Range

PrintGridlines  boolean

PrintHeadings  boolean

PrintNotes  boolean

PrintQuality  integer

PrintTitleColumns  Range

PrintTitleRows  Range

RightFooter  text

RightHeader  text

RightMargin  fixed

TopMargin  fixed

Zoom  integer

Class character: A character

Plural form:

characters

Properties:

color  RGB color  -- the color

font  text  -- the name of the font

size  fixed  -- the size in points

writing code  writing code  [r/o]  -- the script system and language

style  text style info  -- the text style

uniform styles  text style info  [r/o]  -- the text style

Class file: A file

Plural form:

files

Properties:

stationery  boolean  -- Is the file a stationery file?

Class selection-object: the selection visible to the user

Properties:

contents  type class  [r/o]  -- the contents of the selection

Class text: Text

Properties:

font  text  -- the name of the font of the first character

Class text style info: On and Off styles of text run

Plural form:

text style infos

Properties:

on styles  a list of plain/bold/italic/outline/shadow/underline/superscript/subscript/strikethrough/small caps/all caps/all lowercase/condensed/expanded/hidden  [r/o]  -- the styles that are on for the text

off styles  a list of plain/bold/italic/outline/shadow/underline/superscript/subscript/strikethrough/small caps/all caps/all lowercase/condensed/expanded/hidden  [r/o]  -- the styles that are off for the text

Class insertion point: An insertion location between two objects

Plural form:

insertion points


Table Suite

Table Suite: Classes for manipulating tables

Address: Return a text representation of the name of the given range

Address  Range  -- the range

[RowAbsolute  boolean]  -- use absolute row format

[ColumnAbsolute  boolean]  -- use absolute column format

[ReferenceStyle  xlR1C1/xlA1]

[External  boolean]  -- use external name

[RelativeTo  Cell]  -- the cell that the range will be offset from

[Local  boolean]  -- return string in local language?

Result:   text  -- name of given range

AdvancedFilter: Filter a list based on the given criteria

AdvancedFilter  reference  -- the range which contains a list to filter

Action  xlFilterInPlace/xlFilterCopy  -- how to filter

[Criteria  Range]  -- the range which contains the criteria

[CopyTo  Range]  -- where to put the result, required if Action is copy

[Unique  boolean]  -- unique records only

ApplyNames: apply names of cell references to their uses

ApplyNames  reference  -- range where names will be applied

[Name  text]  -- names to apply - missing means all names

[IgnoreRelative  boolean]  -- if absolue/relative should be ignored

[UseRowAndColumnNames  boolean]  -- if row and column names should be used

[OmitColumns  boolean]  -- if columns should be omitted

[OmitRows  boolean]  -- if rows should be omitted

[Order  xlRowThenColumn/xlColumnThenRow]  -- order of range names

[AppendLast  boolean]

ApplyOutlineStyles: apply outlining styles to the given range

ApplyOutlineStyles  reference  -- range where the styles will be applied

AutoFill: perform an auto fill

AutoFill  reference  -- The source range to start the fill

Destination  Range  -- The range to fill in, must contain the source range

[Type  xlFillDefault/xlFillCopy/xlFillSeries/xlFillFormats/xlFillValues/xlFillDays/xlFillWeekdays/xlFillMonths/xlFillYears/xlLinearTrend/xlGrowthTrend]  -- The type of fill to perform

AutoFilter: perform an auto filter

AutoFilter  reference  -- the range to filter

[Field  integer]  -- the index of the field to filter on

[Criteria1  text]  -- The criteria as text

[Operator  xlAnd/xlOr]  -- 1 (AND) or 2 (OR)

[Criteria2  text]  -- Used with Criteria1 and Operator to form compound criteria

AutoFit: Set column width or row height to an auto fit

AutoFit  reference  -- row or column to auto fit

AutoOutline: create an outline for the given range or the entire sheet

AutoOutline  reference  -- The range to create an outline for, if one cell then entire sheet

BorderAround: Put a border around a range

BorderAround  reference  -- range around which to put the border

[LineStyle  xlNone/xlContinuous/xlDash/xlDot/Reserved/Reserved/Reserved/Reserved/Reserved/xlDouble]  -- linestyle of the outline

[Weight  xlHairline/xlThin/xlMedium/xlThick]  -- weight of the outline

[Color  RGB color]  -- color of the outline

[ColorIndex  xlAutomatic]  -- color of the outline as an index into Excel's color palette

ClearNotes: Clear notes from a range of cells

ClearNotes  reference  -- the object to clear

ClearOutline: Clear the outline of a range of cells

ClearOutline  reference  -- the object to clear

ColumnDifferences: returns a range of cells whose contents are different from the comparison cell

ColumnDifferences  reference  -- the range of which to find differences

Comparison  Range  -- the comparison range

Result:   Range  -- different cells

Consolidate: consolidate data on multiple worksheets

Consolidate  reference  -- the cell range to do the consolidation on

[Sources  text]  -- the source data to consolidate

[Function  xlAverage/xlCountNums/xlCount/xlMax/xlMin/xlProduct/xlStDev/xlStDevP/xlSum/xlVar/xlVarP]  -- the aggregator function

[TopRow  boolean]  -- use names in top row of sources to consolidate?

[LeftColumn  boolean]  -- use names in left column of sources to consolidate?

[CreateLinks  boolean]  -- use worksheet links, instead of copying data

CreateNames: create defined names based on the given range

CreateNames  reference  -- the range from which to base the names

[Top  boolean]  -- create names form top row

[Left  boolean]  -- create names from left column

[Bottom  boolean]  -- create names from bottom row

[Right  boolean]  -- create names from right column

Result:   reference

DataSeries: enters a data series in the given range

DataSeries  reference  -- the range in which to enter the series

[RowOrCol  xlRows/xlColumns]  -- enter the series in rows or columns

[Type  xlLinear/xlGrowth/xlChronological/xlAutoFill]  -- the type of series to enter

[Date  xlDay/xlWeekday/xlMonth/xlYear]  -- date unit to step by when type is chronological

[Step  fixed]  -- the number of units to step

[Stop  fixed]  -- the end of the series

[Trend  boolean]

Result:   reference

DialogBox: run an old style dialog box

DialogBox  reference  -- the range that contains the dialog definition

Result:   integer  -- position of control that was chosen

LastCell: Returns the cell at the end of the given range

LastCell  Range  -- the range of whicih to find the end

Direction  xlToLeft/xlToRight/xlUp/xlDown  -- the direction in which to find the end

Result:   Range  -- the cell at the given position

FillDown: fill a range of cells from the top down

FillDown  reference  -- range of cells or group to fill

FillLeft: fill a range of cells from left to right

FillLeft  reference  -- range of cells or group to fill

FillRight: fill a range of cells from right to left

FillRight  reference  -- range of cells or group to fill

FillUp: fill a range of cells from the bottom up

FillUp  reference  -- range of cells or group to fill

Find: search for a string in some object (range, doc, text box)

Find  reference  -- the range to search

What  text  -- the string to search for

[after  Cell]  -- the cell after which to start the search

[LookIn  xlFormulas/xlValues/xlNotes]  -- where to look for the text

[LookAt  xlWhole/xlPart]  -- whether to look at whole or parts of words

[SearchBy  xlByRows/xlByColumns]  -- search order can be row-major or column-major

[direction  xlNext/xlPrevious]  -- direction of search, either next or previous

[MatchCase  boolean]  -- is case significant?

[activate  boolean]  -- activate the result?

Result:   reference  -- the cell which satisfies the seach

FindNext: search for the next cell that contains the last searched for string

FindNext  reference  -- the range to search

[after  Cell]  -- the cell after which to start the search

[activate  boolean]  -- activate the result?

Result:   reference  -- the cell which satisfies the seach

FindPrevious: search for the previous cell that contains the last searched for string

FindPrevious  reference  -- the range to search

[after  Cell]  -- the cell after which to start the search

[activate  boolean]  -- activate the result?

Result:   reference  -- the cell which satisfies the seach

GoalSeek: perform a goal seek

GoalSeek  reference  -- the range to goal seek

Goal  fixed  -- the desired result of the goal seek

Changing  Cell  -- the cell to change to find the goal

Result:   boolean  -- success of not

Justify: Justify to the object

Justify  reference  -- object to justify

NavigateArrow: Navigates a tracer arrow

NavigateArrow  reference  -- the cell containing the tracer arrow

[TowardPrecedent  boolean]  -- point toward precedent?

[ArrowNumber  integer]  -- the arrow corresponding to which reference in formula

[LinkNumber  integer]  -- which external reference to follow

[Result:   reference]  -- a range

NoteText: Set of get the text of a cell's note

NoteText  reference  -- the cell containing the note

[Text  text]  -- text to add to note, if missing then return the note's text

[Start  integer]  -- starting position to insert or retrieve text

[Length  integer]  -- the length of the text to replace or retrieve

Result:   anything  -- either the text of the note or the position of the last character

Offset: return a new range offset from the given range

Offset  Range  -- the range to offset

[RowOffset  integer]  -- how many rows to offset the range

[ColumnOffset  integer]  -- how many rows to offset the range

Result:   Range  -- the new range

Parse: parse data in a cell and break it into multiple cells

Parse  reference  -- the cells to parse

[UsingForm  text]  -- the form of the data to parse

[Destination  reference]  -- the range to put the parsed data

RemoveSubtotal: Remove subtotals from a list

RemoveSubtotal  Range  -- the range

Replace: search for and replace a string

Replace  reference  -- the range to search

What  text  -- the string to search for

[ReplaceWith  text]  -- found text will be replaced by this text (after, look in and direction are not legal with this)

[LookAt  xlWhole/xlPart]  -- whether to look at whole or parts of words

[SearchBy  xlByRows/xlByColumns]  -- search order can be row-major or column-major

[MatchCase  boolean]  -- is case significant?

[Result:   boolean]  -- true, if successful

Resize: return a new range with new dimensions

Resize  Range  -- the range to resize

[RowSize  integer]  -- how many rows to offset the range

[ColumnSize  integer]  -- how many rows to offset the range

Result:   Range  -- the new range

RowDifferences: returns a range of cells whose contents are different from the comparison cell

RowDifferences  reference  -- the range of which to find differences

Comparison  Range  -- the comparison range

Result:   Range  -- different cells

ShowDependents: draws tracer arrows to dependents

ShowDependents  reference  -- the range whose tracers will be drawn

[Remove  boolean]  -- remove or expand a level of tracer arrows

ShowErrors: draws tracer arrows to show erros

ShowErrors  reference  -- the range whose tracers will be drawn

ShowPrecedents: draws tracer arrows to precedents

ShowPrecedents  reference  -- the range whose tracers will be drawn

[Remove  boolean]  -- remove or expand a level of tracer arrows

Sort: sort a range of cells

Sort  reference  -- the range to sort

[Key1  anything]  -- the first field to sort (the field name as text or a range)

[Order1  xlAscending/xlDescending]  -- sort first field in ascending or descending order

[Key2  anything]  -- the second field to sort (the field name as text or a range)

[Order2  xlAscending/xlDescending]  -- sort second field in ascending or descending order

[Key3  anything]  -- the third field to sort (the field name as text or a range)

[Order3  xlAscending/xlDescending]  -- sort third field in ascending or descending order

[type  xlSortValues/xlSortLabels]  -- what pivot table elements to sort

[Header  xlGuess/xlYes/xlNo]  -- does sort range contain a header?

[OrderCustom  integer]  -- custom list to use for sorting

[MatchCase  boolean]  -- case is significant

[Orientation  xlTopToBottom/xlLeftToRight]  -- horizontal or vertical sort

SortSpecial: sort a range of cells

SortSpecial  reference  -- the range to sort

[SortMethod  xlSyllabary/xlCodePage]  -- how to sort

[Key1  anything]  -- the first field to sort (the field name as text or a range)

[Order1  xlAscending/xlDescending]  -- sort first field in ascending or descending order

[Key2  anything]  -- the second field to sort (the field name as text or a range)

[Order2  xlAscending/xlDescending]  -- sort second field in ascending or descending order

[Key3  anything]  -- the third field to sort (the field name as text or a range)

[Order3  xlAscending/xlDescending]  -- sort third field in ascending or descending order

[type  xlSortValues/xlSortLabels]  -- what pivot table elements to sort

[Header  xlGuess/xlYes/xlNo]  -- does sort range contain a header?

[OrderCustom  integer]  -- custom list to use for sorting

[MatchCase  boolean]  -- case is significant

[Orientation  xlTopToBottom/xlLeftToRight]  -- horizontal or vertical sort

SpecialCells: return a range referring to cells that match a certain criterion

SpecialCells  Range  -- the source range

Type  xlNotes/xlConstants/xlFormulas/xlBlanks/Reserved/Reserved/Reserved/Reserved/Reserved/Reserved/xlLastCell/xlVisible  -- the type of cells to return

[Value  integer]  -- what type of formulas and constants to return

Result:   Range

Subtotal: create a subtotal

Subtotal  reference  -- the range for which to create the subtotal

GroupBy  anything  -- the index or name of the field to group

Function  xlSum/xlCount/xlAverage/xlMax/xlMin/xlProduct/xlCountNums/xlStDev/xlStDevP/xlVar/xlVarP  -- the aggregator function

TotalList  integer  -- the aggregator function

[Replace  boolean]  -- replace existing subtotals

[PageBreaks  boolean]  -- create pagebreaks after each group

[SummaryBelowData  boolean]  -- place summary above or below data?

Table: create a table

Table  reference  -- the range from which to create the table

[RowInput  Cell]  -- a single cell used as row input for the table

[ColumnInput  Cell]  -- a single cell used as column input for the table

TextToColumns: Parse a column of cells containing text into several columns

TextToColumns  Range  -- the range to parse

[Destination  Range]  -- where to put the parsed data

[DataType  xlDelimited/xlFixedWidth]  -- is data delimited or fixed width?

[TextQualifier  xlDoubleQuote/xlSingleQuote/xlNone]

[TreatConsecutiveDelimitersAsOne  boolean]

[TabDelimiter  boolean]  -- use tab as a delimiter

[SemicolonDelimiter  boolean]  -- use a semicolon as a delimiter

[CommaDelimiter  boolean]  -- use a comma as a delimiter

[SpaceDelimiter  boolean]  -- use a space as a delimiter

[Other  boolean]  -- other character to use as a delimiter

[OtherCharacter  text]  -- the character to use as a delimiter when Other is true

[FieldInfo  integer]  -- a list of tuples

Class Areas:

Elements:

Areas by numeric index

Class Range: A Range

Elements:

Cell by numeric index, by name

Row by numeric index

Column by numeric index, by name

Range by name

Style by numeric index, by name

Areas by numeric index

Border by numeric index

Characters as a range of elements

Properties:

ActivePivotField  PivotField  [r/o]

ActivePivotItem  PivotItem  [r/o]

ActivePivotTable  PivotTable  [r/o]

AddIndent  boolean

Alignment  xlGeneral/xlLeft/xlCenter/xlRight/xlJustify/xlCenterAcrossSelection/xlFill

Background Color  RGB color

Bold  boolean

Bottom Border  xlNone/xlThin/xlMedium/xlAutomatic/xlDash/xlDot/xlThick/xlDouble/xlHairline

Bottom Border Color  RGB color

Cell Style  text

Color  RGB color

Column  integer  [r/o]

ColumnWidth  fixed

CurrentArray  Range  [r/o]

CurrentRegion  Range  [r/o]

Dependents  Range  [r/o]

DirectDependents  Range  [r/o]

DirectPrecedents  Range  [r/o]

EntireColumn  Range  [r/o]

EntireRow  Range  [r/o]

Font  Font

Foreground Color  RGB color

Formula  text

FormulaArray  text

FormulaHidden  boolean

FormulaLocal  text

FormulaR1C1  text

FormulaR1C1Local  text

HasArray  boolean  [r/o]

HasFormula  boolean  [r/o]

Height  fixed  [r/o]

Hidden  boolean

HorizontalAlignment  xlGeneral/xlLeft/xlCenter/xlRight/xlFill/xlJustify/xlCenterAcrossSelection/xlDistributed

Interior  Interior  [r/o]

Italic  boolean

Left  fixed  [r/o]

Left Border  xlNone/xlThin/xlMedium/xlAutomatic/xlDash/xlDot/xlThick/xlDouble/xlHairline

Left Border Color  RGB color

LocationInTable  xlRowHeader/xlColumnHeader/xlPageHeader/xlDataHeader/xlRowItem/xlColumnItem/xlPageItem/xlDataItem/xlTableBody  [r/o]

Name  text

Next  Range  [r/o]

NumberFormat  text

NumberFormatLocal  text

Orientation  xlHorizontal/xlVertical/xlUpward/xlDownward

Outline  boolean

OutlineLevel  integer

PageBreak  xlNone/xlManual/xlAutomatic

Parent  anything  [r/o]

Pattern  'bwpt'

Plain  boolean

Precedents  Range  [r/o]

PrefixCharacter  text  [r/o]

Previous  Range  [r/o]

Protection  read only/formulas protected/read/write

Right Border  xlNone/xlThin/xlMedium/xlAutomatic/xlDash/xlDot/xlThick/xlDouble/xlHairline

Right Border Color  RGB color

Row  integer  [r/o]

RowHeight  fixed

Shadow  boolean

ShowDetail  boolean

Size  anything

SoundNote  SoundNote  [r/o]

Strikethrough  boolean

Style  Style  [r/o]

Style  text style info

Summary  boolean  [r/o]

Text  text  [r/o]

Top  fixed  [r/o]

Top Border  xlNone/xlThin/xlMedium/xlAutomatic/xlDash/xlDot/xlThick/xlDouble/xlHairline

Top Border Color  RGB color

Underline  boolean

UseStandardHeight  boolean

UseStandardWidth  boolean

Value  anything

VerticalAlignment  xlTop/xlCenter/xlBottom/xlJustify/xlDistributed

Width  fixed  [r/o]

WrapText  boolean

Class Cell: A Cell

Plural form:

Cells

Properties:

Font  Font

class  type class  [r/o]  -- the class

formula  text  -- the formula of the cell

protection  read only/formulas protected/read/write  -- Indicates whether value or formula in the cell can be changed

Class Row: A Row

Plural form:

Rows

Elements:

Cell by numeric index, by name

Class Column: A Column

Plural form:

Columns

Elements:

Cell by numeric index, by name

Properties:

name  string  -- the name

Class table: A table

Plural form:

tables


Charting Suite

Charting Suite: Classes to manipulate charts

AddChartAutoFormat: create a chart auto format

AddChartAutoFormat

BasedOn  Chart  -- the chart to base the auto format on

Name  text  -- name of the chart auto format

[Description  text]  -- description of chart auto format

ApplyDataLabels: apply data labels to a chart, series or point

ApplyDataLabels

[Type  xlNone/xlShowValue/xlShowPercent/xlShowLabel/xlShowLabelAndPercent]  -- the type of data labels to apply

[LegendKey  boolean]  -- display the key next to the label?

ChartWizard: Perform a Chart Wizard

ChartWizard  reference  -- the chart on which to perform the Wizard

[Source  reference]  -- the range which contains data for the chart

[Gallery  xlArea/xlBar/xlColumn/xlLine/xlPie/xlRadar/xlXYScatter/xlCombination/xl3DArea/xl3DBar/xl3DColumn/xl3DLine/xl3DPie/xl3DSurface/xlDoughnut]  -- chart type

[Format  integer]  -- which form of the chart type

[PlotBy  xlRows/xlColumns]  -- is series data in rows or colums?

[NumCategoryLabels  integer]  -- number of rows (or columns) to use for category labels

[NumSeriesLabels  integer]  -- number of rows (or columns) to use for series labels

[HasLegend  boolean]  -- display a legend?

[Title  text]  -- chart title

[CategoryAxisTitle  text]  -- title for the Category axis

[ValueAxisTitle  text]  -- title for the Value axis

[ExtraAxisTitle  text]  -- title for the Series or Second Y axis

DeleteChartAutoFormat: delete a chart auto format

DeleteChartAutoFormat

Name  text  -- which chart auto format to delete

Deselect: remove the selection from a chart

Deselect  reference  -- the chart from which to remove the selection

ErrorBar: Apply Error Bars to a chart series

ErrorBar  Series  -- the series on which to apply error bars

Direction  xlX/xlY  -- error bars in the X or Y direction

Include  xlBoth/xlPlusValues/xlMinusValues/xlNone  -- what error bar parts to include

Type  xlFixedValue/xlPercent/xlStDev/xlStError/xlCustom  -- the type of error bar to apply

[Amount  anything]  -- amount of error to show

[MinusValues  anything]  -- amount to use as minus values when type is custom

ExtendSeries: Add more data points to existing series of a chart

ExtendSeries  reference  -- the series to extend (must be 'every series')

Source  anything  -- a range whose values to add to chart or a list of values

[RowOrCol  xlRows/xlColumns]  -- data is in rows or columns

[CategoryLabels  boolean]  -- Source contains labels

SetDefaultChart: sets the chart formatting for new charts

SetDefaultChart

[FormatName  xlBuiltIn]  -- the name of the chart format or BuiltIn

Class Font: The font for a cell, text box or chart item

Properties:

Background  xlAutomatic/xlTransparent/xlOpaque

Bold  boolean

Color  RGB color

ColorIndex  xlAutomatic

FontStyle  text

Italic  boolean

Name  text

OutlineFont  boolean

Parent  anything  [r/o]

Shadow  boolean

Size  fixed

Strikethrough  boolean

Subscript  boolean

Superscript  boolean

Underline  xlNone/xlSingle/xlDouble/xlSingleAccounting/xlDoubleAccounting

Class Border: A single border

Properties:

Color  RGB color

ColorIndex  xlNone/xlAutomatic

LineStyle  xlAutomatic/xlNone/xlContinuous/xlDash/xlDot/xlDashDot/xlDashDotDot/xlGray50/xlGray75/xlGray25/xlDouble

Parent  anything  [r/o]

Weight  xlHairline/xlThin/xlMedium/xlThick

Class Borders: Collection of cell borders

Elements:

Border by numeric index

Properties:

Color  RGB color

ColorIndex  xlNone/xlAutomatic

LineStyle  xlAutomatic/xlNone/xlContinuous/xlDash/xlDot/xlDashDot/xlDashDotDot/xlGray50/xlGray75/xlGray25/xlDouble

Parent  anything  [r/o]

Value  xlAutomatic/xlNone/xlContinuous/xlDash/xlDot/xlDashDot/xlDashDotDot/xlGray50/xlGray75/xlGray25/xlDouble

Weight  xlHairline/xlThin/xlMedium/xlThick

Class Corners: The corners of a 3D chart

Properties:

Name  text  [r/o]

Parent  anything  [r/o]

Class SeriesLines: The lines which connect series.

Properties:

Border  Border  [r/o]

Class HiloLines: The HiLo lines of a chart

Class Gridlines: The gridlines on an axis of a chart

Class DropLines: The DropLines on a chart

Class ErrorBars: The error bars on a chart

Properties:

EndStyle  xlCap/xlNoCap

Class UpBars: The UpBars on a chart

Properties:

Interior  Interior  [r/o]

Class DownBars: The DownBars on a chart

Class ChartTitle: The title of the chart

Elements:

Characters as a range of elements

Properties:

Caption  text

Font  Font

HorizontalAlignment  xlLeft/xlCenter/xlRight/xlJustify/xlDistributed

Left  fixed  [r/o]

Orientation  xlHorizontal/xlVertical/xlUpward/xlDownward

Shadow  boolean

Text  text

Top  fixed  [r/o]

VerticalAlignment  xlTop/xlCenter/xlBottom/xlJustify/xlDistributed

Class ChartText: The title text of the chart

Properties:

Background Color  RGB color

Bold  boolean

Color  RGB color

Font  text

Foreground Color  RGB color

Italic  boolean

Outline  boolean

Pattern  'bwpt'

Plain  boolean

Shadow  boolean

Size  anything

Strikethrough  boolean

Style  text style info

Underline  boolean

Class AxisTitle: The title of an axis of the chart

Elements:

Characters as a range of elements

Class Floor: The floor of a 3D chart

Properties:

Border  Border  [r/o]

Interior  Interior  [r/o]

Class Walls: The walls of a 3D chart

Class PlotArea: The plot area of a chart

Properties:

Border  Border  [r/o]

Height  fixed  [r/o]

Interior  Interior  [r/o]

Left  fixed  [r/o]

Top  fixed  [r/o]

Width  fixed  [r/o]

Class ChartArea: The chart area of a chart

Properties:

Font  Font

Shadow  boolean

Class Legend: The legend of a chart

Elements:

LegendEntry by numeric index

Properties:

Font  Font

Position  xlBottom/xlCorner/xlTop/xlRight/xlLeft

Shadow  boolean

Class TickLabels: The ticklabels on a chart axis

Properties:

Font  Font

Name  text  [r/o]

NumberFormat  text

NumberFormatLinked  text

Orientation  xlHorizontal/xlVertical/xlUpward/xlDownward/xlAutomatic

Parent  anything  [r/o]

Class Chart: A chart sheet or chart object on a worksheet

Plural form:

Charts

Elements:

Series by numeric index, by name

AxisGroup by numeric index

Axis by numeric index, by name

ChartGroup by numeric index

AreaGroup by numeric index

BarGroup by numeric index

ColumnGroup by numeric index

LineGroup by numeric index

PieGroup by numeric index

DoughnutGroup by numeric index

RadarGroup by numeric index

XYGroup by numeric index

DrawingObject by numeric index, by name

GroupObject by numeric index, by name

ChartObject by numeric index, by name

Line by numeric index, by name

Rectangle by numeric index, by name

Oval by numeric index, by name

Arc by numeric index, by name

OLEObject by numeric index, by name

TextBox by numeric index, by name

Picture by numeric index, by name

Drawing by numeric index, by name

Button by numeric index, by name

CheckBox by numeric index, by name

OptionButton by numeric index, by name

ScrollBar by numeric index, by name

ListBox by numeric index, by name

GroupBox by numeric index, by name

DropDown by numeric index, by name

Spinner by numeric index, by name

Label by numeric index, by name

EditBox by numeric index, by name

Properties:

Area3DGroup  ChartGroup

AutoScaling  boolean

Background Color  RGB color

Bar3DGroup  ChartGroup

ChartArea  ChartArea  [r/o]

ChartTitle  ChartTitle  [r/o]

Column3DGroup  ChartGroup

Corners  Corners  [r/o]

DepthPercent  fixed

DisplayBlanksAs  xlNotPlotted/xlZero/xlInterpolated

Elevation  integer

Floor  Floor  [r/o]

Foreground Color  RGB color

GapDepth  integer

HasAxis  boolean

HasLegend  boolean

HasTitle  boolean

HeightPercent  fixed

Legend  Legend  [r/o]

Line3DGroup  ChartGroup

NumberOfSeries  anything  [r/o]

Pattern  'bwpt'

Perspective  integer

Pie3DGroup  ChartGroup

PlotArea  PlotArea  [r/o]

PlotVisibleOnly  boolean

Rightangleaxes  boolean

Rotation  fixed

SizeWithWindow  boolean

SubType  integer

SurfaceGroup  ChartGroup

Title  ChartText  [r/o]

Type  xlArea/xlBar/xlColumn/xlLine/xlPie/xlDoughnut/xlRadar/xlXYScatter/xl3DArea/xl3DBar/xl3DColumn/xl3DLine/xl3DPie/xl3DSurface

Variant  anything  [r/o]

Walls  Walls  [r/o]

WallsandGridlinesAre2D  boolean

Class ChartGroup: A layer of the chart

Plural form:

ChartGroups

Elements:

Series by numeric index, by name

Properties:

AxisGroup  integer

DoughnutHoleSize  integer

DownBars  DownBars  [r/o]

DropLines  DropLines  [r/o]

FirstSliceAngle  integer

GapWidth  integer

HasDropLines  boolean

HasHiloLines  boolean

HasRadarAxisLabels  boolean

HasSeriesLines  boolean

HasUpdownBars  boolean

HiloLines  HiloLines  [r/o]

Overlap  integer

Parent  anything  [r/o]

RadarAxisLabels  Axis  [r/o]

SeriesLines  SeriesLines  [r/o]

SubType  integer

Type  xlArea/xlBar/xlColumn/xlLine/xlPie/xlDoughnut/xlRadar/xlXYScatter/xl3DArea/xl3DBar/xl3DColumn/xl3DLine/xl3DPie/xl3DSurface

UpBars  UpBars  [r/o]

VaryByCategories  boolean

Class AreaGroup: Accessor returns an Area Chart as a Layer object

Plural form:

AreaGroups

Class BarGroup: Accessor returns a Bar Chart as a Layer object

Plural form:

BarGroups

Class ColumnGroup: Accessor returns a Column Chart as a Layer object

Plural form:

ColumnGroups

Class LineGroup: Accessor returns a Line Chart as a Layer object

Plural form:

LineGroups

Class PieGroup: Accessor returns a Pie Chart as a Layer object

Plural form:

PieGroups

Class DoughnutGroup: Accessor returns a Doughnut Chart as a Layer object

Plural form:

DoughnutGroups

Class RadarGroup: Accessor returns a Radar Chart as a Layer object

Plural form:

RadarGroups

Class XYGroup: Accessor returns a Scatter Chart as a Layer object

Plural form:

XYGroups

Class AxisGroup: All this class does is let you access an axis in the secondary axis group

Elements:

Axis by numeric index, by name

Class Axis: One of the (up to) four axes on a chart

Plural form:

Axes

Properties:

AxisBetweenCategories  integer

AxisGroup  xlPrimary/xlSecondary

AxisTitle  AxisTitle  [r/o]

Border  Border  [r/o]

CategoryNames  text  [r/o]

Crosses  xlAutomatic/xlMinimumOrMaximum/xlCustom

CrossesAt  integer

HasMajorGridlines  boolean

HasMinorGridlines  boolean

HasTitle  boolean

IsVisible  boolean

Label  ChartText

MajorGridlines  Gridlines  [r/o]

MajorStep  anything

MajorTickMark  xlNone/xlInside/xlOutside/xlCross

MajorTickType  anything

MajorUnit  integer

MajorUnitIsAuto  boolean

Max  anything

MaximumScale  integer

MaximumScaleIsAuto  boolean

Min  anything

MinimumScale  integer

MinimumScaleIsAuto  boolean

MinorGridlines  Gridlines  [r/o]

MinorStep  anything

MinorTickMark  xlNone/xlInside/xlOutside/xlCross

MinorTickType  anything

MinorUnit  integer

MinorUnitIsAuto  boolean

Parent  anything  [r/o]

ReversePlotOrder  integer

ScaleType  xlLinear/xlLogarithmic

TickLabelPosition  xlNone/xlLow/xlHigh/xlNextToAxis

TickLabelSpacing  integer

TickLabels  TickLabels  [r/o]

TickMarkSpacing  integer

Type  xlCategory/xlValue/xlSeries

Class DataLabel: a data label for a chart point

Plural form:

DataLabels

Elements:

Characters as a range of elements

Properties:

AutoText  boolean

NumberFormat  text

NumberFormatLinked  text

Parent  anything  [r/o]

ShowLegendKey  boolean

Type  xlNone/xlShowValue/xlShowPercent/xlShowLabel/xlShowLabelAndPercent

Class Point: A single chart point

Plural form:

Points

Properties:

Border  Border  [r/o]

DataLabel  DataLabel  [r/o]

Explosion  integer  [r/o]

HasDataLabel  boolean

Interior  Interior  [r/o]

InvertIfNegative  boolean

MarkerBackgroundColor  RGB color

MarkerBackgroundColorIndex  xlNone

MarkerForegroundColor  RGB color

MarkerForegroundColorIndex  xlNone

MarkerStyle  xlAutomatic/xlNone/xlSquare/xlDiamond/xlTriangle/xlX/xlStar/xlDot/xlDash/xlCircle/xlPlus/xlPicture

Parent  anything  [r/o]

PictureType  xlStretch/xlStack/xlScale  [r/o]

PictureUnit  integer  [r/o]

Class Series: A series in a chart

Plural form:

SeriesCollection

Elements:

Point by numeric index

DataLabel by numeric index

Trendline by numeric index

Properties:

AxisGroup  integer

Background Color  RGB color

Border  Border  [r/o]

ErrorBars  ErrorBars  [r/o]

Explosion  integer  [r/o]

Foreground Color  RGB color

Formula  text

FormulaLocal  text

FormulaR1C1  text

FormulaR1C1Local  text

HasDataLabels  boolean

HasErrorBars  boolean

Interior  Interior  [r/o]

InvertIfNegative  boolean

MarkerBackgroundColor  RGB color

MarkerBackgroundColorIndex  xlNone

MarkerForegroundColor  RGB color

MarkerForegroundColorIndex  xlNone

MarkerStyle  xlAutomatic/xlNone/xlSquare/xlDiamond/xlTriangle/xlX/xlStar/xlDot/xlDash/xlCircle/xlPlus/xlPicture

Name  text

Parent  anything  [r/o]

Pattern  'bwpt'

PictureType  xlStretch/xlStack/xlScale  [r/o]

PictureUnit  integer  [r/o]

PlotOrder  integer

Smooth  boolean

Type  xlArea/xlBar/xlColumn/xlLine/xlPie/xlDoughnut/xlRadar/xlXYScatter/xl3DArea/xl3DBar/xl3DColumn/xl3DLine/xl3DPie/xl3DSurface

Values  fixed

XValues  fixed

Class LegendEntry: An entry in the legend

Plural form:

LegendEntries

Properties:

Font  Font

Index  integer

LegendKey  LegendKey

Parent  anything  [r/o]

Class LegendKey: A marker in an entry of the legend

Properties:

Border  Border  [r/o]

Interior  Interior  [r/o]

InvertIfNegative  boolean

MarkerBackgroundColor  RGB color

MarkerBackgroundColorIndex  xlNone

MarkerForegroundColor  RGB color

MarkerForegroundColorIndex  xlNone

MarkerStyle  xlAutomatic/xlNone/xlSquare/xlDiamond/xlTriangle/xlX/xlStar/xlDot/xlDash/xlCircle/xlPlus/xlPicture

Parent  anything  [r/o]

Smooth  boolean

Class Trendline: A trendline attached to a series on a chart

Plural form:

Trendlines

Properties:

Backward  integer

Border  Border  [r/o]

DataLabel  DataLabel  [r/o]

DisplayEquation  boolean

DisplayRSquared  boolean

Forward  fixed

Index  integer

Intercept  fixed

InterceptIsAuto  boolean

Name  text

NameIsAuto  boolean

Order  integer

Parent  anything  [r/o]

Period  integer

Type  xlLinear/xlLogarithmic/xlPolynomial/xlPower/xlExponential/xlMovingAvg


Mail Suite

Mail Suite: Apple Open Collaboration Environment related Apple Events

ForwardMailer: Sets up a workbook mailer for forwarding

ForwardMailer  Workbook  -- the workbook which gets set up for forwarding

LogoffMail: Closes a mail session

LogoffMail

LogonMail: Opens a mail session

LogonMail

[Name  text]  -- the mail account name to open

[Password  text]  -- the password to open this mail account

[DownloadNewMail  boolean]  -- whether or not to download new mail

NextLetter: Opens the next Excel letter from the In Tray

NextLetter

Reply: Creates a workbook to reply to the given workbook

Reply  Workbook  -- workbook must contain a mailer

[Result:   Workbook]  -- the newly created reply workbook

ReplyAll: Creates a workbook to reply to the given workbook

ReplyAll  Workbook  -- workbook must contain a mailer

[Result:   Workbook]  -- the newly created reply workbook

Route: Route the given workbook using the current routing slip

Route  Workbook  -- workbook must contain a mailer

SendMailer: Send object as mail

SendMailer  reference  -- the object to send

[Priority  xlNormal/xlLow/xlHigh]  -- priority of the mail

[As  xlNormal/xlSYLK/xlText/xlWKS/xlWK1/xlCSV/xlDBF2/xlDBF3/xlDIF/Reserved/xlDBF4/Reserved/Reserved/xlWJ2WD1/xlWK3/xlExcel2/xlTemplate/xlAddIn/xlTextMac/xlTextWindows/xlTextMSDOS/xlCSVMac/xlCSVWindows/xlCSVMSDOS/xlIntlMacro/xlIntlAddIn/xlExcel2FarEast/...]  -- Excel file type of the document to be sent

SendMail: Send some mail

SendMail  Workbook  -- the workbook to send

Recipients  text  -- who to send to

[Subject  text]  -- subject of mail

[ReturnReceipt  boolean]  -- return receipt requested

Class Mailer: The Workbook's PowerTalk Mailer

Properties:

BCCRecipients  text

CCRecipients  text

Enclosures  text

Parent  anything  [r/o]

ReceivedStatus  boolean  [r/o]

Sender  text  [r/o]

Subject  text

Time/DateSent  text  [r/o]

ToRecipients  text

WhichAddress  text

Class RoutingSlip: A Routing Slip

Properties:

Delivery  xlOneAfterAnother/xlAllAtOnce

Message  text

Parent  anything  [r/o]

Recipients  text

ReturnWhenDone  boolean

Status  xlNotYetRouted/xlRoutingInProgress/xlRoutingComplete  [r/o]

Subject  text

TrackStatus  boolean


Elements

An element is a class of object that can be contained within another object.  An object containing an element is known as a container.