| || _Evaluate || |
| || _FindFile || |
| || _Run2 || |
| || _Wait || |
| || _WSFunction || |
| || 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.
| || AddChartAutoFormat ||
Adds a custom chart autoformat to the list of available chart autoformats.
| || AddCustomList ||
Adds a custom list for custom autofill and/or custom sort.
| || Calculate ||
Calculates all open workbooks
| || 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.
| || 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. Returns True if the word is found in one of the dictionaries; returns False if the word isn't found.
| || ConvertFormula ||
Converts cell references in a formula between the A1 and R1C1 reference styles, between relative and absolute references, or both.
| || 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.
| || DeleteChartAutoFormat ||
Removes a custom chart autoformat from the list of available chart autoformats.
| || 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.
| || Dummy1 || |
| || Dummy10 || |
| || Dummy11 || |
| || Dummy12 || |
| || Dummy13 || |
| || Dummy14 || |
| || Dummy2 || |
| || Dummy3 || |
| || Dummy4 || |
| || Dummy5 || |
| || Dummy6 || |
| || Dummy7 || |
| || Dummy8 || |
| || Dummy9 || |
| || 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 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.
| || 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 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.
| || 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.
| || ResetTipWizard || |
| || Run ||
Runs a macro or calls a function.
| || Save || |
| || SaveWorkspace ||
Saves the current workspace.
| || SendKeys ||
Sends keystrokes to the active application.
| || SetDefaultChart ||
Specifies the name of the chart template that Microsoft Excel will use when creating new charts.
| || Support || |
| || 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.