Application Methods (Excel)
This object has the following methods:
Methods
Name |
Description |
---|---|
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. |
|
Adds a custom list for custom autofill and/or custom sort. |
|
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. |
|
Forces a full calculation of the data in all open workbooks. |
|
For all open workbooks, forces a full calculation of the data and rebuilds the dependencies. |
|
Runs all pending queries to OLEDB and OLAP data sources. |
|
Converts a measurement from centimeters to points (one point equals 0.035 centimeters). |
|
Stops recalculation in a Microsoft Excel application. |
|
Checks the spelling of a single word. |
|
Converts cell references in a formula between the A1 and R1C1 reference styles, between relative and absolute references, or both. Variant. |
|
Runs a command or performs some other action or actions in another application by way of the specified DDE channel. |
|
Opens a DDE channel to an application. |
|
Sends data to an application. |
|
Requests information from the specified application. This method always returns an array. |
|
Closes a channel to another application. |
|
Deletes a custom list. |
|
Opens the XML Source task pane and displays the XML map specified by the XmlMap argument. |
|
Equivalent to double-clicking the active cell. |
|
Converts a Microsoft Excel name to an object or a value. |
|
Runs a Microsoft Excel 4.0 macro function and then returns the result of the function. The return type depends on the function. |
|
Displays the Open dialog box. |
|
Returns a custom list (an array of strings). |
|
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. |
|
Displays the standard Open dialog box and gets a file name from the user without actually opening any files. |
|
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. |
|
Displays the standard Save As dialog box and gets a file name from the user without actually saving any files. |
|
Selects any range or Visual Basic procedure in any workbook, and activates that workbook if it’s not already active. |
|
Displays a Help topic. |
|
Converts a measurement from inches to points. |
|
Displays a dialog box for user input. Returns the information entered in the dialog box. |
|
Returns a Range object that represents the rectangular intersection of two or more ranges. |
|
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. |
|
Closes a MAPI mail session established by Microsoft Excel. |
|
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. |
|
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. |
|
Runs a specified procedure when a particular key or key combination is pressed. |
|
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. |
|
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). |
|
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. |
|
Quits Microsoft Excel. |
|
Records code if the macro recorder is on. |
|
Loads an XLL code resource and automatically registers the functions and commands contained in the resource. |
|
Repeats the last user-interface action. |
|
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. |
|
Saves the current workspace. |
|
Sends keystrokes to the active application. |
|
Returns the version number of SharePoint Foundation instances running at site for the specified URL. |
|
Cancels the last user-interface action. |
|
Returns the union of two or more ranges. |
|
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. |
|
Pauses a running macro until a specified time. Returns True if the specified time has arrived. |