Application Methods (Excel)

Published: July 16, 2012

This object has the following methods:

Name

Description

ActivateMicrosoftApp

Activates a Microsoft application. If the application is already running, this method activates the running application. If the application isn't running, this method starts a new instance of the application.

AddCustomList

Adds a custom list for custom autofill and/or custom sort.

Calculate

Calculates all open workbooks, a specific worksheet in a workbook, or a specified range of cells on a worksheet, as shown in the following table.

CalculateFull

Forces a full calculation of the data in all open workbooks.

CalculateFullRebuild

For all open workbooks, forces a full calculation of the data and rebuilds the dependencies.

CalculateUntilAsyncQueriesDone

Runs all pending queries to OLEDB and OLAP data sources.

CentimetersToPoints

Converts a measurement from centimeters to points (one point equals 0.035 centimeters).

CheckAbort

Stops recalculation in a Microsoft Excel application.

CheckSpelling

Checks the spelling of a single word.

ConvertFormula

Converts cell references in a formula between the A1 and R1C1 reference styles, between relative and absolute references, or both. Variant.

DDEExecute

Runs a command or performs some other action or actions in another application by way of the specified DDE channel.

DDEInitiate

Opens a DDE channel to an application.

DDEPoke

Sends data to an application.

DDERequest

Requests information from the specified application. This method always returns an array.

DDETerminate

Closes a channel to another application.

DeleteCustomList

Deletes a custom list.

DisplayXMLSourcePane

Opens the XML Source task pane and displays the XML map specified by the XmlMap argument.

DoubleClick

Equivalent to double-clicking the active cell.

Evaluate

Converts a Microsoft Excel name to an object or a value.

ExecuteExcel4Macro

Runs a Microsoft Excel 4.0 macro function and then returns the result of the function. The return type depends on the function.

FindFile

Displays the Open dialog box.

GetCustomListContents

Returns a custom list (an array of strings).

GetCustomListNum

Returns the custom list number for an array of strings. You can use this method to match both built-in lists and custom-defined lists.

GetOpenFilename

Displays the standard Open dialog box and gets a file name from the user without actually opening any files.

GetPhonetic

Returns the Japanese phonetic text of the specified text string. This method is available to you only if you have selected or installed Japanese language support for Microsoft Office.

GetSaveAsFilename

Displays the standard Save As dialog box and gets a file name from the user without actually saving any files.

Goto

Selects any range or Visual Basic procedure in any workbook, and activates that workbook if it’s not already active.

Help

Displays a Help topic.

InchesToPoints

Converts a measurement from inches to points.

InputBox

Displays a dialog box for user input. Returns the information entered in the dialog box.

Intersect

Returns a Range object that represents the rectangular intersection of two or more ranges.

MacroOptions

Corresponds to options in the Macro Options dialog box. You can also use this method to display a user defined function (UDF) in a built-in or new category within the Insert Function dialog box.

MailLogoff

Closes a MAPI mail session established by Microsoft Excel.

MailLogon

Logs in to MAPI Mail or Microsoft Exchange and establishes a mail session. If Microsoft Mail isn't already running, you must use this method to establish a mail session before mail or document routing functions can be used.

NextLetter

You have requested Help for a Visual Basic keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition.

OnKey

Runs a specified procedure when a particular key or key combination is pressed.

OnRepeat

Sets the Repeat item and the name of the procedure that will run if you choose the Repeat command after running the procedure that sets this property.

OnTime

Schedules a procedure to be run at a specified time in the future (either at a specific time of day or after a specific amount of time has passed).

OnUndo

Sets the text of the Undo command and the name of the procedure that’s run if you choose the Undo command after running the procedure that sets this property.

Quit

Quits Microsoft Excel.

RecordMacro

Records code if the macro recorder is on.

RegisterXLL

Loads an XLL code resource and automatically registers the functions and commands contained in the resource.

Repeat

Repeats the last user-interface action.

Run

Runs a macro or calls a function. This can be used to run a macro written in Visual Basic or the Microsoft Excel macro language, or to run a function in a DLL or XLL.

SaveWorkspace

Saves the current workspace.

SendKeys

Sends keystrokes to the active application.

SharePointVersion

Returns the version number of SharePoint Foundation instances running at site for the specified URL.

Undo

Cancels the last user-interface action.

Union

Returns the union of two or more ranges.

Volatile

Marks a user-defined function as volatile. A volatile function must be recalculated whenever calculation occurs in any cells on the worksheet. A nonvolatile function is recalculated only when the input variables change. This method has no effect if it's not inside a user-defined function used to calculate a worksheet cell.

Wait

Pauses a running macro until a specified time. Returns True if the specified time has arrived.

Show:
© 2014 Microsoft