Application methods
Office 2013 and later
The Application type exposes the following members.
| Name | Description | |
|---|---|---|
|
_Evaluate | Reserved for internal use. (Inherited from _Application.) |
|
_FindFile | Reserved for internal use. (Inherited from _Application.) |
|
_Run2 | Reserved for internal use. (Inherited from _Application.) |
|
_Wait | Reserved for internal use. (Inherited from _Application.) |
|
_WSFunction | Reserved for internal use. (Inherited from _Application.) |
|
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. (Inherited from _Application.) |
|
AddChartAutoFormat | Adds a custom chart autoformat to the list of available chart autoformats. (Inherited from _Application.) |
|
AddCustomList | Adds a custom list for custom autofill and/or custom sort. (Inherited from _Application.) |
|
Calculate | Calculates all open workbooks (Inherited from _Application.) |
|
CalculateFull | Forces a full calculation of the data in all open workbooks. (Inherited from _Application.) |
|
CalculateFullRebuild | For all open workbooks, forces a full calculation of the data and rebuilds the dependencies. (Inherited from _Application.) |
|
CalculateUntilAsyncQueriesDone | Runs all pending queries to OLEDB and OLAP data sources. (Inherited from _Application.) |
|
CentimetersToPoints | Converts a measurement from centimeters to points (one point equals 0.035 centimeters). (Inherited from _Application.) |
|
CheckAbort | Stops recalculation in a Microsoft Excel application. (Inherited from _Application.) |
|
CheckSpelling | Checks the spelling of a single word. Returns True if the word is found in one of the dictionaries; returns False if the word isn't found. (Inherited from _Application.) |
|
ConvertFormula | Converts cell references in a formula between the A1 and R1C1 reference styles, between relative and absolute references, or both. (Inherited from _Application.) |
|
DDEExecute | Runs a command or performs some other action or actions in another application by way of the specified DDE channel. (Inherited from _Application.) |
|
DDEInitiate | Opens a DDE channel to an application. (Inherited from _Application.) |
|
DDEPoke | Sends data to an application. (Inherited from _Application.) |
|
DDERequest | Requests information from the specified application. This method always returns an array. (Inherited from _Application.) |
|
DDETerminate | Closes a channel to another application. (Inherited from _Application.) |
|
DeleteChartAutoFormat | Removes a custom chart autoformat from the list of available chart autoformats. (Inherited from _Application.) |
|
DeleteCustomList | Deletes a custom list. (Inherited from _Application.) |
|
DisplayXMLSourcePane | Opens the XML Source task pane and displays the XML map specified by the XmlMap argument. (Inherited from _Application.) |
|
DoubleClick | Equivalent to double-clicking the active cell. (Inherited from _Application.) |
|
Dummy1 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy10 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy11 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy12 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy13 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy14 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy2 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy20 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy3 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy4 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy5 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy6 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy7 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy8 | Reserved for internal use. (Inherited from _Application.) |
|
Dummy9 | Reserved for internal use. (Inherited from _Application.) |
|
Evaluate | Converts a Microsoft Excel name to an object or a value. (Inherited from _Application.) |
|
ExecuteExcel4Macro | Runs a Microsoft Excel 4.0 macro function, and then returns the result of the function. The return type depends on the function. (Inherited from _Application.) |
|
FindFile | Displays the Open dialog box. (Inherited from _Application.) |
|
GetCustomListContents | Returns a custom list (an array of strings). (Inherited from _Application.) |
|
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. (Inherited from _Application.) |
|
GetOpenFilename | Displays the standard Open dialog box and gets a file name from the user without actually opening any files. (Inherited from _Application.) |
|
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. (Inherited from _Application.) |
|
GetSaveAsFilename | Displays the standard Save As dialog box and gets a file name from the user without actually saving any files. (Inherited from _Application.) |
|
Goto | Selects any range or Visual Basic procedure in any workbook and activates that workbook if it’s not already active. (Inherited from _Application.) |
|
Help | Displays a Help topic. (Inherited from _Application.) |
|
InchesToPoints | Converts a measurement from inches to points. (Inherited from _Application.) |
|
InputBox | Displays a dialog box for user input. Returns the information entered in the dialog box. (Inherited from _Application.) |
|
Intersect | Returns a Range object that represents the rectangular intersection of two or more ranges. (Inherited from _Application.) |
|
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. (Inherited from _Application.) |
|
MacroOptions2 | Reserved for internal use. (Inherited from _Application.) |
|
MailLogoff | Closes a MAPI mail session established by Microsoft Excel. (Inherited from _Application.) |
|
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. (Inherited from _Application.) |
|
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. (Inherited from _Application.) |
|
OnKey | Runs a specified procedure when a particular key or key combination is pressed. (Inherited from _Application.) |
|
OnRepeat | Sets the Repeat menu item and the name of the procedure that will run if you choose the Repeat command (Edit menu) after running the procedure that sets this property. (Inherited from _Application.) |
|
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). (Inherited from _Application.) |
|
OnUndo | Sets the text of the Undo and the name of the procedure that’s run if you choose the Undo command (Edit menu) after running the procedure that sets this property. (Inherited from _Application.) |
|
Quit | Quits Microsoft Excel. (Inherited from _Application.) |
|
RecordMacro | Records code if the macro recorder is on. (Inherited from _Application.) |
|
RegisterXLL | Loads an XLL code resource and automatically registers the functions and commands contained in the resource. (Inherited from _Application.) |
|
Repeat | Repeats the last user interface action. (Inherited from _Application.) |
|
ResetTipWizard | Resets the routing slip so that a new routing can be initiated with the same slip (using the same recipient list and delivery information). The routing must be completed before you use this method. Using this method at other times causes an error. (Inherited from _Application.) |
|
Run | Runs a macro or calls a function. (Inherited from _Application.) |
|
Save | Saves changes to the specified workbook. (Inherited from _Application.) |
|
SaveWorkspace | This object, member, or enumeration is deprecated and is not intended to be used in your code. (Inherited from _Application.) |
|
SendKeys | Sends keystrokes to the active application. (Inherited from _Application.) |
|
SetDefaultChart | Specifies the name of the chart template that Microsoft Excel will use when creating new charts. (Inherited from _Application.) |
|
SharePointVersion | Returns the version number of SharePoint Foundation instances running at site for the specified URL. (Inherited from _Application.) |
|
Support | Reserved for internal use. (Inherited from _Application.) |
|
Undo | Cancels the last user interface action. (Inherited from _Application.) |
|
Union | Returns the union of two or more ranges. (Inherited from _Application.) |
|
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. (Inherited from _Application.) |
|
Wait | Pauses a running macro until a specified time. Returns True if the specified time has arrived. (Inherited from _Application.) |
Show: