_Application Methods

The _Application type exposes the following members.

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