Application Methods

Name

Returns Parameters Description

Activate MicrosoftApp

AddCustomList

Index As XlMS Application

ListArray, [ByRow]

Calculate

CalculateFull

Activates an application specified by XlMSApplication. Opens the application if it is not open. Acts in a similar manner as the GetObject function in VBA

Adds the array of strings specified by ListArray to Excel's custom lists. The ListArray may also be a cell range

Calculates all the formulas in all open workbooks that have changed since the last calculation. Only applicable if using manual calculation

Calculates all the formulas in all open workbooks. Forces recalculation of every formula in every workbook, regardless of whether or not it has changed since the last calculation

Name

Returns

Parameters

Description

CalculateFullRebuild

Forces a full calculation of the data and rebuilds the dependencies for all open workbooks. Note that dependencies are the formulas that depend on other cells

CalculateUnit

AsyncQueries

Done

Runs all pending queries to OLEDB and OLAP data sources

CentimetersTo Points

Double

Centimeters As Double

Converts the Centimeters parameter to points, where 1 cm = 28.35 points

CheckAbort

-

[KeepAbort]

Stops any recalculations in an Excel application

CheckSpelling [Custom Dictionary], [Ignore Uppercase]

Boolean

Word As String,

Checks the spelling of the Word parameter and returns True if the spelling is correct, or False if there are errors

Convert Formula

Variant

Formula, FromReference Style As XlReference Style,

[ToReference Style] , [ToAbsolute], [RelativeTo]

Converts the Formula parameter between R1C1 references and A1 references and returns the converted formula. Also, can change the Formula parameter between relative references and absolute references using the ToReferenceStyle parameter and the XlReferenceStyle constants

DDEExecute

Channel As Long, String As String

Sends a Command to an application using DDE through the given Channel number. The properties starting with DDE are associated with the older technology, Dynamic Data Exchange, which was used to share data between applications

DDEInitiate

Long

App As String, Topic As String

Returns a channel number to use for DDE given an application name and the DDE topic

DDEPoke

Channel As Long, Item, Data

Sends Data to an item in an application using DDE through the given Channel number

DDERequest

Variant

Channel As Long, Item As String

Returns information, given a specific DDE channel and a requested item

Name

Returns

Parameters

Description

DDETerminate

Channel As Long

Closes the specified DDE channel

DeleteCustom List

ListNum As Long

Deletes the custom list specified by the list number. The first four lists are built into Excel and cannot be removed

DisplayXML SourcePane

Activates the XML Source task pane

DoubleClick

Triggered by a double-click to the active cell in the active sheet

Evaluate

Variant

Name

Evaluates the Name string expression as if it were entered into a worksheet cell

ExecuteExcel4 Macro

Variant

String As String

Executes the Excel 4 macro specified by the String parameter and returns the results

FindFile

Boolean

Shows the Open dialog box, allowing the user to choose a file to open. True is returned if the file opens successfully

GetCustomList Contents

Variant

ListNum As Long

Returns the custom list specified by the ListNum parameter as an array of strings

GetCustom ListNum

Long

ListArray

Returns the list number for the custom list that matches the given array of strings. 0 is returned if nothing matches

GetOpen Filename

[Filterlndex],

[ButtonText],

[MultiSelect]

The Open dialog box is displayed with the optional file filters, titles, and button texts specified by the parameters. The filename and path are returned from this method call. Optionally, can return an array of filenames if the MultiSelect parameter is True. Does not actually open the file

GetPhonetic

String

[Text]

Returns the phonetic text of the Japanese characters in the Text parameter. If no Text parameter is specified, then an alternate phonetic text of the previous Text parameter is returned

GetSaveAs Filename

Filename],

[FileFilter],

[Filterlndex],

[ButtonText]

The Save As dialog box is displayed with the optional default filename, file filters, titles, and button texts specified by the parameters. The filename and path are returned from this method call. Does not actually save the file

Name Returns Parameters Description

Goto [Reference], Selects the object specified by the

[Scroll] Reference parameter and activates the sheet containing that object. The Reference parameter can be a cell, a range, or the name of a VBA procedure. The Scroll parameter, if set to True, will scroll the selected object to the top-left corner of the Excel window

Help

[HelpFile], [HelpContextID]

Displays the Help topic specified by the HelpContextID parameter in the Help file HelpFile

InchesTo Points

Double

Inches As Double

Converts the Inches parameter to points and returns the new value (1 inch = 72 points)

InputBox

[Default],

[HelpFile],

[HelpContextID],

[Type]

Displays a simple input box, very similar to a standard VBA one. However, the [Type] parameter can be used to set the return type to a formula (0), a number (1), text (2), a Boolean (4), a cell reference (8), an error value (16), or an array of values (64)

Intersect

Range

Argl As Range, Arg2 As Range, [Arg3], [Arg30]

Returns the intersection or overlap of the ranges specified by the parameters as a Range object

MacroOptions

[Macro], [Description], [HasMenu], [MenuText], [HasShortcut Key], [ShortcutKey], [Category] , [StatusBar], [HelpContext ID], [HelpFile]

Allows modification of macro attributes such as the name, description, shortcut key, category, and associated Help file. Equivalent to the Macro Options dialog box

MailLogoff

Logs off the current MAPI mail session (for example, Exchange, Outlook)

MailLogon

[Name], [Password], [DownloadNewMail]

Logs on to the default MAPI mail client (for example, Exchange, Outlook). Credentials such as name and password can be specified

Name

Returns

Parameters

Description

NextLetter

Workbook

Used in Macintosh systems with PowerTalk mail extensions to open the oldest unread workbook from the In Tray. Generates an error in Windows

OnKey

Key As String, [Procedure]

Executes the procedure specified by the Procedure parameter whenever the keystroke or key combination described in the Key parameter is pressed

OnRepeat

Text As String, Procedure As String

Specifies the procedure that will run when the user chooses the Repeat command

OnTime

EarliestTime, Procedure As String, [LatestTime], [Schedule]

Chooses a procedure to run at the time specified by the EarliestTime parameter. Uses the LatestTime parameter to specify a time range

OnUndo

Text As String, Procedure As String

Specifies the procedure to run when the user chooses the Undo command

Quit

Shuts down Microsoft Excel

RecordMacro

[Basic Code], [XlmCode]

If the user is currently recording a macro, running this statement will put the code specified in the BasicCode parameter into the currently recording macro

RegisterXLL

Boolean

Filename As String

Loads the code resource specified by the Filename parameter, and registers all the functions and procedures in that code resource

Repeat

Repeats the last user action made. Must be the first line of a procedure

Run

Variant

[Macro], [Argl], [Arg2], ( [Arg3 0]

Runs the macro or procedure specified by the Macro parameter. Can also run Excel 4.0 macros with this method

SaveWorkspace

[Filename]

Saves the current workspace to the Filename parameter

SendKeys

Keys, [Wait]

Sends the keystrokes in the Keys parameter to Microsoft Excel user interface

Undo

Undoes the last action done with the user interface

Name Returns Parameters Description

Union

Range

Volatile

Wait

[Volatile]

Boolean

Time

Returns the union of the ranges specified by the parameters

Sets the function that currently contains this statement to be either volatile (Volatile parameter to True) or not. A volatile function will be recalculated whenever the sheet containing it is calculated, even if its input values have not changed

Pauses the macro and Excel until the time in the Time parameter is reached

0 0

Post a comment