Application Application Application Interface

Definition

Represents the entire Microsoft Excel application.

public interface class Application : Microsoft::Office::Interop::Excel::_Application, Microsoft::Office::Interop::Excel::AppEvents_Event
[System.Runtime.InteropServices.Guid("000208D5-0000-0000-C000-000000000046")]
public interface Application : Microsoft.Office.Interop.Excel._Application, Microsoft.Office.Interop.Excel.AppEvents_Event
Public Interface Application
Implements _Application, AppEvents_Event
Derived
Attributes
Implements

Remarks

This is a .NET interface derived from a COM coclass that is required by managed code for interoperability with the corresponding COM object. Use this derived interface to access all method, property, and event members of the COM object. However, if a method or event you want to use shares the same name under the same COM object, cast to the corresponding primary interface to call the method, and cast to the latest events interface to connect to the event. Refer to this topic for information about the COM object. For information about the method and property members of the COM object, see _Application.

The Application object contains:

  • Application-wide settings and options (for example, many of the options in the Options dialog box - accessed through the Tools menu).
  • Properties that return top-level objects, such as ActiveCell, ActiveSheet, and so on.

Use the Application property to return the Application object.

Properties

ActiveCell ActiveCell ActiveCell

Returns a Range object that represents the active cell in the active window (the window on top) or in the specified window. If the window isn't displaying a worksheet, this property fails.

(Inherited from _Application)

ActiveChart ActiveChart ActiveChart

Returns a Chart object that represents the active chart (either an embedded chart or a chart sheet). An embedded chart is considered active when it's either selected or activated. When no chart is active, this property returns Nothing.

(Inherited from _Application)

ActiveDialog ActiveDialog ActiveDialog

Reserved for internal use.

(Inherited from _Application)

ActiveEncryptionSession ActiveEncryptionSession ActiveEncryptionSession

Read-only.

(Inherited from _Application)

ActiveMenuBar ActiveMenuBar ActiveMenuBar

Reserved for internal use.

(Inherited from _Application)

ActivePrinter ActivePrinter ActivePrinter

Returns or sets the name of the active printer.

(Inherited from _Application)

ActiveProtectedViewWindow ActiveProtectedViewWindow ActiveProtectedViewWindow

Gets a ProtectedViewWindow object that represents the active Protected View window (the window on top).

(Inherited from _Application)

ActiveSheet ActiveSheet ActiveSheet

Returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. Returns Nothing if no sheet is active.

(Inherited from _Application)

ActiveWindow ActiveWindow ActiveWindow

Returns a Window object that represents the active window (the window on top). Returns Nothing if there are no windows open.

(Inherited from _Application)

ActiveWorkbook ActiveWorkbook ActiveWorkbook

Returns a Workbook object that represents the workbook in the active window (the window on top). Returns Nothing if there are no windows open or if either the Info window or the Clipboard window is the active window.

(Inherited from _Application)

AddIns AddIns AddIns

Returns an AddIns collection that represents all the add-ins listed in the Add-Ins dialog box (Tools menu).

(Inherited from _Application)

AddIns2 AddIns2 AddIns2

Gets a collection of AddIns2 objects that represent all the add-ins that are currently available or open in Excel, regardless of whether they are installed.

(Inherited from _Application)

AlertBeforeOverwriting AlertBeforeOverwriting AlertBeforeOverwriting

True if Microsoft Excel displays a message before overwriting nonblank cells during a drag-and-drop editing operation.

(Inherited from _Application)

AltStartupPath AltStartupPath AltStartupPath

Returns or sets the name of the alternate startup folder.

(Inherited from _Application)

AlwaysUseClearType AlwaysUseClearType AlwaysUseClearType

Returns or sets a Boolean that represents whether to use ClearType to display fonts in the menu, Ribbon, and dialog box text. Read/write.

(Inherited from _Application)

AnswerWizard AnswerWizard AnswerWizard

Returns the AnswerWizard object for Microsoft Excel.

(Inherited from _Application)

Application Application Application

Returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object).

(Inherited from _Application)

ArbitraryXMLSupportAvailable ArbitraryXMLSupportAvailable ArbitraryXMLSupportAvailable

Returns a Boolean value that indicates whether the XML features in Microsoft Excel are available.

(Inherited from _Application)

True if Microsoft Excel asks the user to update links when opening files with links. False if links are automatically updated with no dialog box.

(Inherited from _Application)

Assistance Assistance Assistance

Returns an IAssistance object for short_Excel2007 that represents the Microsoft Office Help Viewer. Read-only.

(Inherited from _Application)

Assistant Assistant Assistant

Returns an Assistant object for Microsoft Excel.

(Inherited from _Application)

AutoCorrect AutoCorrect AutoCorrect

Returns an AutoCorrect object that represents the Microsoft Excel AutoCorrect attributes.

(Inherited from _Application)

True (default) if Microsoft Excel automatically formats hyperlinks as you type. False if Excel does not automatically format hyperlinks as you type.

(Inherited from _Application)

AutomationSecurity AutomationSecurity AutomationSecurity

Returns or sets an MsoAutomationSecurity constant that represents the security mode Microsoft Excel uses when programmatically opening files.

(Inherited from _Application)

AutoPercentEntry AutoPercentEntry AutoPercentEntry

True if entries in cells formatted as percentages aren’t automatically multiplied by 100 as soon as they are entered.

(Inherited from _Application)

AutoRecover AutoRecover AutoRecover

Returns an AutoRecover object, which backs up all file formats on a timed interval.

(Inherited from _Application)

Build Build Build

Returns the Microsoft Excel build number.

(Inherited from _Application)

CalculateBeforeSave CalculateBeforeSave CalculateBeforeSave

True if workbooks are calculated before they're saved to disk (if the Calculation property is set to xlManual). This property is preserved even if you change the Calculation property.

(Inherited from _Application)

Calculation Calculation Calculation

Returns or sets the calculation mode. Read/write XlCalculation.

(Inherited from _Application)

CalculationInterruptKey CalculationInterruptKey CalculationInterruptKey

Sets or returns an XlCalculationInterruptKey constant that specifies the key that can interrupt Microsoft Excel when performing calculations.

(Inherited from _Application)

CalculationState CalculationState CalculationState

Returns an XlCalculationState constant that indicates the calculation state of the application for any calculations that are being performed in Microsoft Excel.

(Inherited from _Application)

CalculationVersion CalculationVersion CalculationVersion

Returns a number whose rightmost four digits are the minor calculation engine version number, and whose other digits (on the left) are the major version of Microsoft Excel.

(Inherited from _Application)

Caller[Object] Caller[Object] Caller[Object]

Returns information about how Visual Basic was called (for more information, see the Remarks section).

(Inherited from _Application)

CanPlaySounds CanPlaySounds CanPlaySounds

This property should not be used. Sound notes have been removed from Microsoft Excel.

(Inherited from _Application)

CanRecordSounds CanRecordSounds CanRecordSounds

This property should not be used. Sound notes have been removed from Microsoft Excel.

(Inherited from _Application)

Caption Caption Caption

The name that appears in the title bar of the main Microsoft Excel window. If you don't set a name, or if you set the name to Empty, this property returns "Microsoft Excel".

(Inherited from _Application)

CellDragAndDrop CellDragAndDrop CellDragAndDrop

True if dragging and dropping cells is enabled.

(Inherited from _Application)

Cells Cells Cells

Returns a Range object that represents all the cells on the active worksheet. If the active document isn’t a worksheet, this property fails.

(Inherited from _Application)

ChartDataPointTrack ChartDataPointTrack ChartDataPointTrack

True will cause all charts in newly created documents to use the cell reference tracking behavior. Boolean (bool in C#).

(Inherited from _Application)

Charts Charts Charts

Returns a Sheets collection that represents all the chart sheets in the active workbook.

(Inherited from _Application)

ClipboardFormats[Object] ClipboardFormats[Object] ClipboardFormats[Object]

Returns the formats that are currently on the Clipboard as an array of numeric values. To determine whether a particular format is on the Clipboard, compare each element in the array with the appropriate constant listed in the Remarks section.

(Inherited from _Application)

ClusterConnector ClusterConnector ClusterConnector

Gets or sets the name of the High Performance Computing (HPC) Cluster Connector that is used to run user-defined functions in XLL add-ins.

(Inherited from _Application)

ColorButtons ColorButtons ColorButtons

Reserved for internal use.

(Inherited from _Application)

Columns Columns Columns

Returns a Range object that represents all the columns on the active worksheet. If the active document isn't a worksheet, the Columns property fails.

(Inherited from _Application)

COMAddIns COMAddIns COMAddIns

Returns the COMAddIns collection for Microsoft Excel, which represents the currently installed COM add-ins.

(Inherited from _Application)

CommandBars CommandBars CommandBars

Returns a CommandBars object that represents the Excel command bars.

(Inherited from _Application)

CommandUnderlines CommandUnderlines CommandUnderlines

Returns or sets the state of the command underlines in Microsoft Excel for the Macintosh.

(Inherited from _Application)

ConstrainNumeric ConstrainNumeric ConstrainNumeric

True if handwriting recognition is limited to numbers and punctuation only.

(Inherited from _Application)

ControlCharacters ControlCharacters ControlCharacters

True if Microsoft Excel displays control characters for right-to-left languages.

(Inherited from _Application)

CopyObjectsWithCells CopyObjectsWithCells CopyObjectsWithCells

True if objects are cut, copied, extracted, and sorted with cells.

(Inherited from _Application)

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C.

(Inherited from _Application)

Cursor Cursor Cursor

Returns or sets the appearance of the mouse pointer in Microsoft Excel.

(Inherited from _Application)

CursorMovement CursorMovement CursorMovement

Returns or sets a value that indicates whether a visual cursor or a logical cursor is used. Can be one of the following constants: xlVisualCursor or xlLogicalCursor.

(Inherited from _Application)

CustomListCount CustomListCount CustomListCount

Returns the number of defined custom lists (including built-in lists).

(Inherited from _Application)

CutCopyMode CutCopyMode CutCopyMode

Returns or sets the status of Cut or Copy mode.

(Inherited from _Application)

DataEntryMode DataEntryMode DataEntryMode

Returns or sets Data Entry mode, as shown in the table below. When in Data Entry mode, you can enter data only in the unlocked cells in the currently selected range.

(Inherited from _Application)

DDEAppReturnCode DDEAppReturnCode DDEAppReturnCode

Returns the application-specific DDE return code that was contained in the last DDE acknowledge message received by Excel.

(Inherited from _Application)

DecimalSeparator DecimalSeparator DecimalSeparator

Sets or returns the character used for the decimal separator as a String.

(Inherited from _Application)

DefaultFilePath DefaultFilePath DefaultFilePath

Returns or sets the default path that Microsoft Excel uses when it opens files.

(Inherited from _Application)

DefaultSaveFormat DefaultSaveFormat DefaultSaveFormat

Returns or sets the default format for saving files.

(Inherited from _Application)

DefaultSheetDirection DefaultSheetDirection DefaultSheetDirection

Returns or sets the default direction in which Microsoft Excel displays new windows and worksheets. Can be one of the following constants: xlRTL (right to left) or xlLTR (left to right).

(Inherited from _Application)

DefaultWebOptions DefaultWebOptions DefaultWebOptions

Returns the DefaultWebOptions object that contains global application-level attributes used by Microsoft Excel whenever you save a document as a Web page or open a Web page.

(Inherited from _Application)

DeferAsyncQueries DeferAsyncQueries DeferAsyncQueries

Gets or sets whether asychronous queries to OLAP data sources are executed when a worksheet is calculated by VBA code. Read/write.

(Inherited from _Application)

Dialogs Dialogs Dialogs

Returns a Dialogs collection that represents all built-in dialog boxes.

(Inherited from _Application)

DialogSheets DialogSheets DialogSheets

Reserved for internal use.

(Inherited from _Application)

DisplayAlerts DisplayAlerts DisplayAlerts

True if Microsoft Excel displays certain alerts and messages while a macro is running.

(Inherited from _Application)

DisplayClipboardWindow DisplayClipboardWindow DisplayClipboardWindow

Returns True if the Microsoft Office Clipboard can be displayed.

(Inherited from _Application)

DisplayCommentIndicator DisplayCommentIndicator DisplayCommentIndicator

Returns or sets the way cells display comments and indicators. Can be one of the following XlCommentDisplayMode constants: xlNoIndicator, xlCommentIndicatorOnly, or xlCommentAndIndicator.

(Inherited from _Application)

DisplayDocumentActionTaskPane DisplayDocumentActionTaskPane DisplayDocumentActionTaskPane

Set to True to display the Document Actions task pane; set to False to hide the Document Actions task pane.

(Inherited from _Application)

DisplayDocumentInformationPanel DisplayDocumentInformationPanel DisplayDocumentInformationPanel

Returns or sets a Boolean that represents whether the document properties panel is displayed. Read/write.

(Inherited from _Application)

DisplayExcel4Menus DisplayExcel4Menus DisplayExcel4Menus

True if Microsoft Excel displays version 4.0 menu bars.

(Inherited from _Application)

DisplayFormulaAutoComplete DisplayFormulaAutoComplete DisplayFormulaAutoComplete

Gets or sets whether to show a list of relevant functions and defined names when building cell formulas. Read/write.

(Inherited from _Application)

DisplayFormulaBar DisplayFormulaBar DisplayFormulaBar

True if the formula bar is displayed.

(Inherited from _Application)

DisplayFullScreen DisplayFullScreen DisplayFullScreen

True if Microsoft Excel is in full-screen mode.

(Inherited from _Application)

DisplayFunctionToolTips DisplayFunctionToolTips DisplayFunctionToolTips

True if function ToolTips can be displayed.

(Inherited from _Application)

DisplayInfoWindow DisplayInfoWindow DisplayInfoWindow

Reserved for internal use.

(Inherited from _Application)

DisplayInsertOptions DisplayInsertOptions DisplayInsertOptions

True if the Insert Options button should be displayed.

(Inherited from _Application)

DisplayNoteIndicator DisplayNoteIndicator DisplayNoteIndicator

True if cells containing notes display cell tips and contain note indicators (small dots in their upper-right corners).

(Inherited from _Application)

DisplayPasteOptions DisplayPasteOptions DisplayPasteOptions

True if the Paste Options button can be displayed.

(Inherited from _Application)

DisplayRecentFiles DisplayRecentFiles DisplayRecentFiles

True if the list of recently used files is displayed on the File menu.

(Inherited from _Application)

DisplayScrollBars DisplayScrollBars DisplayScrollBars

True if scroll bars are visible for all workbooks.

(Inherited from _Application)

DisplayStatusBar DisplayStatusBar DisplayStatusBar

True if the status bar is displayed.

(Inherited from _Application)

Dummy101 Dummy101 Dummy101

Reserved for internal use.

(Inherited from _Application)

Dummy22 Dummy22 Dummy22

Inherited from _Application

Dummy23 Dummy23 Dummy23

Inherited from _Application

EditDirectlyInCell EditDirectlyInCell EditDirectlyInCell

True if Microsoft Excel allows editing in cells.

(Inherited from _Application)

EnableAnimations EnableAnimations EnableAnimations

This object, member, or enumeration is deprecated and is not intended to be used in your code.

(Inherited from _Application)

EnableAutoComplete EnableAutoComplete EnableAutoComplete

True if the AutoComplete feature is enabled.

(Inherited from _Application)

EnableCancelKey EnableCancelKey EnableCancelKey

Controls how Microsoft Excel handles CTRL+BREAK (or ESC or COMMAND+PERIOD) user interruptions to the running procedure. Read/write XlEnableCancelKey.

(Inherited from _Application)

EnableCheckFileExtensions EnableCheckFileExtensions EnableCheckFileExtensions

True to enable the Tell me if Microsoft Excel isn't the default program for viewing and editing spreadsheets dialog box.

(Inherited from _Application)

EnableEvents EnableEvents EnableEvents

True if events are enabled for the specified object.

(Inherited from _Application)

EnableLargeOperationAlert EnableLargeOperationAlert EnableLargeOperationAlert

Sets or returns a Boolean that represents whether to display an alert message when a user attempts to perform an operation that affects a larger number of cells than is specified in the Office center UI. Read/write.

(Inherited from _Application)

EnableLivePreview EnableLivePreview EnableLivePreview

Sets or returns a Boolean that represents whether to show or hide gallery previews that appear when using galleries that support previewing. Setting this property to True shows a preview of your workbook before applying the command. Read/write.

(Inherited from _Application)

EnableMacroAnimations EnableMacroAnimations EnableMacroAnimations

Controls whether macro animations are enabled. True if user interface animations or chart animations are enabled. Is set to False (no animation) by default. If it is set to True during the running of a macro, it will enable animation and then will reset to False after the macro runs. Read/write Boolean (bool in C#).

(Inherited from _Application)

EnableSound EnableSound EnableSound

True if sound is enabled for Microsoft Office.

(Inherited from _Application)

EnableTipWizard EnableTipWizard EnableTipWizard

Reserved for internal use.

(Inherited from _Application)

ErrorCheckingOptions ErrorCheckingOptions ErrorCheckingOptions

Returns an ErrorCheckingOptions object, which represents the error checking options for an application.

(Inherited from _Application)

Excel4IntlMacroSheets Excel4IntlMacroSheets Excel4IntlMacroSheets

Returns a Sheets collection that represents all the Microsoft Excel 4.0 international macro sheets in the specified workbook.

(Inherited from _Application)

Excel4MacroSheets Excel4MacroSheets Excel4MacroSheets

Returns a Sheets collection that represents all the Microsoft Excel 4.0 macro sheets in the specified workbook.

(Inherited from _Application)

ExtendList ExtendList ExtendList

True if Microsoft Excel automatically extends formatting and formulas to new data that is added to a list.

(Inherited from _Application)

FeatureInstall FeatureInstall FeatureInstall

Returns or sets a value (constant) that specifies how Microsoft Excel handles calls to methods and properties that require features that aren’t yet installed. Read/write MsoFeatureInstall.

(Inherited from _Application)

FileConverters[Object, Object] FileConverters[Object, Object] FileConverters[Object, Object]

Returns information about installed file converters. Returns Null if there are no converters installed.

(Inherited from _Application)

FileDialog[MsoFileDialogType] FileDialog[MsoFileDialogType] FileDialog[MsoFileDialogType]

Returns a FileDialog object representing an instance of the file dialog.

(Inherited from _Application)

FileExportConverters FileExportConverters FileExportConverters

Returns a FileExportConverters collection that represents all the file converters for saving files available to Microsoft Excel. Read-only.

(Inherited from _Application)

FileFind FileFind FileFind

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)

FileSearch FileSearch FileSearch

Returns a FileSearch object for use with file searches. This property is available only in Microsoft Windows.

(Inherited from _Application)

FileValidation FileValidation FileValidation

Gets or sets how Microsoft Excel will validate files before opening them.

(Inherited from _Application)

FileValidationPivot FileValidationPivot FileValidationPivot

Gets or sets how Microsoft Excel will validate the contents of the data caches for PivotTable reports.

(Inherited from _Application)

FindFormat FindFormat FindFormat

Sets or returns the search criteria for the type of cell formats to find.

(Inherited from _Application)

FixedDecimal FixedDecimal FixedDecimal

All data entered after this property is set to True will be formatted with the number of fixed decimal places set by the FixedDecimalPlaces property.

(Inherited from _Application)

FixedDecimalPlaces FixedDecimalPlaces FixedDecimalPlaces

Returns or sets the number of fixed decimal places used when the FixedDecimal property is set to True.

(Inherited from _Application)

FlashFill FlashFill FlashFill

TRUE indicates that the Excel Flash Fill feature has been enabled and active. Boolean (bool in C#) Read/Write

(Inherited from _Application)

FlashFillMode FlashFillMode FlashFillMode

True if the Flash Fill feature is enabled. Boolean (bool in C#) Read/Write

(Inherited from _Application)

FormulaBarHeight FormulaBarHeight FormulaBarHeight

Allows the user to specify the height of the formula bar in lines. Read/write.

(Inherited from _Application)

GenerateGetPivotData GenerateGetPivotData GenerateGetPivotData

Returns True when Microsoft Excel can get PivotTable report data.

(Inherited from _Application)

GenerateTableRefs GenerateTableRefs GenerateTableRefs

The GenerateTableRefs property determines whether the traditional notation method or the new structured referencing notation method is used for referencing tables in formulas. Read/write.

(Inherited from _Application)

Height Height Height

The height, in points, of the main application window. If the window is minimized, this property is read-only and refers to the height of the icon. If the window is maximized, this property cannot be set. Use the WindowState property to determine the window state.

(Inherited from _Application)

HighQualityModeForGraphics HighQualityModeForGraphics HighQualityModeForGraphics

Gets or sets whether Excel uses high quality mode to print graphics.

(Inherited from _Application)

Hinstance Hinstance Hinstance

Returns the instance handle of the instance that is calling Microsoft Excel.

(Inherited from _Application)

HinstancePtr HinstancePtr HinstancePtr

Gets a handle to the instance of Microsoft Excel 2010 represented by the specified _Application object.

(Inherited from _Application)

Hwnd Hwnd Hwnd

Returns an Integer indicating the top-level window handle of the Microsoft Excel window.

(Inherited from _Application)

IgnoreRemoteRequests IgnoreRemoteRequests IgnoreRemoteRequests

True if remote DDE requests are ignored.

(Inherited from _Application)

Interactive Interactive Interactive

True if Microsoft Excel is in interactive mode; this property is usually True. If you set this property to False, Microsoft Excel will block all input from the keyboard and mouse (except input to dialog boxes that are displayed by your code). Blocking user input will prevent the user from interfering with the code as it moves or activates Microsoft Excel objects.

(Inherited from _Application)

International[Object] International[Object] International[Object]

Returns information about the current country/region and international settings.

(Inherited from _Application)

IsSandboxed IsSandboxed IsSandboxed

Gets whether the specified workbook is open in a Protected View window.

(Inherited from _Application)

Iteration Iteration Iteration

True if Microsoft Excel will use iteration to resolve circular references.

(Inherited from _Application)

LanguageSettings LanguageSettings LanguageSettings

Returns the LanguageSettings object, which contains information about the language settings in Microsoft Excel.

(Inherited from _Application)

LargeButtons LargeButtons LargeButtons

Reserved for internal use.

(Inherited from _Application)

LargeOperationCellThousandCount LargeOperationCellThousandCount LargeOperationCellThousandCount

Returns or sets the maximum number of cells needed in an operation beyond which an alert is triggered. Read/write.

(Inherited from _Application)

Left Left Left

The distance, in points, from the left edge of the screen to the left edge of the main Microsoft Excel window.

(Inherited from _Application)

LibraryPath LibraryPath LibraryPath

Returns the path to the Library folder but without the final separator.

(Inherited from _Application)

MailSession MailSession MailSession

Returns the MAPI mail session number as a hexadecimal string (if there's an active session), or returns Null if there's no session.

(Inherited from _Application)

MailSystem MailSystem MailSystem

Returns the mail system that's installed on the host machine. Read-only XlMailSystem.

(Inherited from _Application)

MapPaperSize MapPaperSize MapPaperSize

True if documents formatted for the standard paper size of another country/region (for example, A4) are automatically adjusted so that they're printed correctly on the standard paper size (for example, Letter) of your country/region.

(Inherited from _Application)

MathCoprocessorAvailable MathCoprocessorAvailable MathCoprocessorAvailable

True if a math coprocessor is available.

(Inherited from _Application)

MaxChange MaxChange MaxChange

Returns or sets the maximum amount of change between each iteration as Microsoft Excel resolves circular references.

(Inherited from _Application)

MaxIterations MaxIterations MaxIterations

Returns or sets the maximum number of iterations that Microsoft Excel can use to resolve a circular reference.

(Inherited from _Application)

MeasurementUnit MeasurementUnit MeasurementUnit

Specifies the measurement unit used in the application. Read/write Integer value corresponding to the constants in the XlMeasurementUnits enumeration.

(Inherited from _Application)

MemoryFree MemoryFree MemoryFree

Returns the amount of memory that's still available for Microsoft Excel to use, in bytes.

(Inherited from _Application)

MemoryTotal MemoryTotal MemoryTotal

Reserved for internal use.

(Inherited from _Application)

MemoryUsed MemoryUsed MemoryUsed

Reserved for internal use.

(Inherited from _Application)

MenuBars MenuBars MenuBars

Reserved for internal use.

(Inherited from _Application)

MergeInstances MergeInstances MergeInstances

True to merge multiple instances of the application into a single instance.

(Inherited from _Application)

Modules Modules Modules

Reserved for internal use.

(Inherited from _Application)

MouseAvailable MouseAvailable MouseAvailable

True if a mouse is available.

(Inherited from _Application)

MoveAfterReturn MoveAfterReturn MoveAfterReturn

True if the active cell will be moved as soon as the ENTER (RETURN) key is pressed.

(Inherited from _Application)

MoveAfterReturnDirection MoveAfterReturnDirection MoveAfterReturnDirection

Returns or sets the direction in which the active cell is moved when the user presses ENTER. Read/write XlDirection.

(Inherited from _Application)

MultiThreadedCalculation MultiThreadedCalculation MultiThreadedCalculation

Returns a MultiThreadedCalculation object that controls the multi-threaded recalculation settings that are new in Excel 2007. Read-only.

(Inherited from _Application)

Name Name Name

Returns the name of the object.

(Inherited from _Application)

Names Names Names

Returns a Names collection that represents all the names in the active workbook.

(Inherited from _Application)

NetworkTemplatesPath NetworkTemplatesPath NetworkTemplatesPath

Returns the network path where templates are stored. If the network path doesn’t exist, this property returns an empty string.

(Inherited from _Application)

ODBCErrors ODBCErrors ODBCErrors

Returns an ODBCErrors collection that contains all the ODBC errors generated by the most recent query table or PivotTable report operation.

(Inherited from _Application)

ODBCTimeout ODBCTimeout ODBCTimeout

Returns or sets the ODBC query time limit in seconds. The default value is 45 seconds.

(Inherited from _Application)

OLEDBErrors OLEDBErrors OLEDBErrors

Returns the OLEDBErrors collection, which represents the error information returned by the most recent OLE DB query.

(Inherited from _Application)

OnCalculate OnCalculate OnCalculate

Reserved for internal use.

(Inherited from _Application)

OnData OnData OnData

Reserved for internal use.

(Inherited from _Application)

OnDoubleClick OnDoubleClick OnDoubleClick

Reserved for internal use.

(Inherited from _Application)

OnEntry OnEntry OnEntry

Reserved for internal use.

(Inherited from _Application)

OnSheetActivate OnSheetActivate OnSheetActivate

Reserved for internal use.

(Inherited from _Application)

OnSheetDeactivate OnSheetDeactivate OnSheetDeactivate

Reserved for internal use.

(Inherited from _Application)

OnWindow OnWindow OnWindow

Returns or sets the name of the procedure that’s run whenever you activate a window.

(Inherited from _Application)

OperatingSystem OperatingSystem OperatingSystem

Returns the name and version number of the current operating system, for example, "Windows (32-bit) 4.00" or "Macintosh 7.00".

(Inherited from _Application)

OrganizationName OrganizationName OrganizationName

Returns the registered organization name.

(Inherited from _Application)

Parent Parent Parent

Returns the parent object for the specified object.

(Inherited from _Application)

Path Path Path

Returns the complete path to the application, excluding the final separator and name of the application.

(Inherited from _Application)

PathSeparator PathSeparator PathSeparator

Returns the path separator character ("").

(Inherited from _Application)

PivotTableSelection PivotTableSelection PivotTableSelection

True if PivotTable reports use structured selection.

(Inherited from _Application)

PreviousSelections[Object] PreviousSelections[Object] PreviousSelections[Object]

Returns an array of the last four ranges or names selected. Each element in the array is a Range object.

(Inherited from _Application)

PrintCommunication PrintCommunication PrintCommunication

Gets or sets whether communication with the printer is turned on.

(Inherited from _Application)

ProductCode ProductCode ProductCode

Returns the globally unique identifier (GUID) for Microsoft Excel.

(Inherited from _Application)

PromptForSummaryInfo PromptForSummaryInfo PromptForSummaryInfo

True if Microsoft Excel asks for summary information when files are first saved.

(Inherited from _Application)

ProtectedViewWindows ProtectedViewWindows ProtectedViewWindows

Gets a ProtectedViewWindows collection that represents all the Protected View windows that are open in the application.

(Inherited from _Application)

QuickAnalysis QuickAnalysis QuickAnalysis

Returns a QuickAnalysis object that represents the Quick Analysis options of the application.

(Inherited from _Application)

Quitting Quitting Quitting

Reserved for internal use.

(Inherited from _Application)

Range[Object, Object] Range[Object, Object] Range[Object, Object]

Returns a Range object that represents a cell or a range of cells.

(Inherited from _Application)

Ready Ready Ready

Returns True when the Microsoft Excel application is ready; False when the Excel application is not ready.

(Inherited from _Application)

RecentFiles RecentFiles RecentFiles

Returns a RecentFiles collection that represents the list of recently used files.

(Inherited from _Application)

RecordRelative RecordRelative RecordRelative

True if macros are recorded using relative references; False if recording is absolute.

(Inherited from _Application)

ReferenceStyle ReferenceStyle ReferenceStyle

Returns or sets how Microsoft Excel displays cell references and row and column headings in either A1 or R1C1 reference style. Read/write XlReferenceStyle.

(Inherited from _Application)

RegisteredFunctions[Object, Object] RegisteredFunctions[Object, Object] RegisteredFunctions[Object, Object]

Returns information about functions in either dynamic-link libraries (DLLs) or code resources that were registered with the REGISTER or REGISTER.ID macro functions.

(Inherited from _Application)

ReplaceFormat ReplaceFormat ReplaceFormat

Sets the replacement criteria to use in replacing cell formats. The replacement criteria is then used in a subsequent call to the Replace(Object, Object, Object, Object, Object, Object, Object, Object) method of the Range object.

(Inherited from _Application)

RollZoom RollZoom RollZoom

True if the IntelliMouse zooms instead of scrolling.

(Inherited from _Application)

Rows Rows Rows

Returns a Range object that represents all the rows on the active worksheet. If the active document isn’t a worksheet, the Rows property fails.

(Inherited from _Application)

RTD RTD RTD

Returns an RTD object.

(Inherited from _Application)

SaveISO8601Dates SaveISO8601Dates SaveISO8601Dates

This object, member, or enumeration is deprecated and is not intended to be used in your code.

(Inherited from _Application)

ScreenUpdating ScreenUpdating ScreenUpdating

True if screen updating is turned on.

(Inherited from _Application)

Selection Selection Selection

Returns the selected object in the active window.

(Inherited from _Application)

Sheets Sheets Sheets

Returns a Sheets collection that represents all the sheets in the active workbook.

(Inherited from _Application)

SheetsInNewWorkbook SheetsInNewWorkbook SheetsInNewWorkbook

Returns or sets the number of sheets that Microsoft Excel automatically inserts into new workbooks.

(Inherited from _Application)

ShortcutMenus[Int32] ShortcutMenus[Int32] ShortcutMenus[Int32]

Reserved for internal use.

(Inherited from _Application)

ShowChartTipNames ShowChartTipNames ShowChartTipNames

True if charts show chart tip names. The default value is True.

(Inherited from _Application)

ShowChartTipValues ShowChartTipValues ShowChartTipValues

True if charts show chart tip values. The default value is True.

(Inherited from _Application)

ShowDevTools ShowDevTools ShowDevTools

Returns or sets a Boolean that represents whether the Developer tab is displayed in the Ribbon. Read/write.

(Inherited from _Application)

ShowMenuFloaties ShowMenuFloaties ShowMenuFloaties

Returns or sets a Boolean that represents whether to display Mini toolbars when the user right-clicks in the workbook window. Read/write.

(Inherited from _Application)

ShowQuickAnalysis ShowQuickAnalysis ShowQuickAnalysis

Controls whether the Quick Analysis contextual user interface is displayed on selection. TRUE means the Quick Analysis button will show. Corresponds to the Show Quick Analysis options on selection checkbox located in the File menu, Options, Excel Options, and then General tab. Read/Write. Boolean (bool in C#).

(Inherited from _Application)

ShowSelectionFloaties ShowSelectionFloaties ShowSelectionFloaties

Returns or sets a Boolean that represents whether Mini toolbars displays when a user selects text. Read/write.

(Inherited from _Application)

ShowStartupDialog ShowStartupDialog ShowStartupDialog

Returns True (default) when the New Workbook task pane appears for a Microsoft Excel application.

(Inherited from _Application)

ShowToolTips ShowToolTips ShowToolTips

True if ToolTips are turned on.

(Inherited from _Application)

ShowWindowsInTaskbar ShowWindowsInTaskbar ShowWindowsInTaskbar

This object, member, or enumeration is deprecated and is not intended to be used in your code.

(Inherited from _Application)

SmartArtColors SmartArtColors SmartArtColors

Gets the set of color styles that are currently loaded in the application.

(Inherited from _Application)

SmartArtLayouts SmartArtLayouts SmartArtLayouts

Gets the set of SmartArt layouts that are currently loaded in the application.

(Inherited from _Application)

SmartArtQuickStyles SmartArtQuickStyles SmartArtQuickStyles

Gets the set of SmartArt quick styles which are currently loaded in the application.

(Inherited from _Application)

SmartTagRecognizers SmartTagRecognizers SmartTagRecognizers

Returns a SmartTagRecognizers collection for an application.

(Inherited from _Application)

Speech Speech Speech

Returns a Speech object.

(Inherited from _Application)

SpellingOptions SpellingOptions SpellingOptions

Returns a SpellingOptions object that represents the spelling options of the application.

(Inherited from _Application)

StandardFont StandardFont StandardFont

Returns or sets the name of the standard font.

(Inherited from _Application)

StandardFontSize StandardFontSize StandardFontSize

Returns or sets the standard font size, in points.

(Inherited from _Application)

StartupPath StartupPath StartupPath

Returns the complete path of the startup folder excluding the final separator.

(Inherited from _Application)

StatusBar StatusBar StatusBar

Returns or sets the text in the status bar.

(Inherited from _Application)

TemplatesPath TemplatesPath TemplatesPath

Returns the local path where templates are stored.

(Inherited from _Application)

ThisCell ThisCell ThisCell

Returns the cell the user-defined function is being called from as a Range object.

(Inherited from _Application)

ThisWorkbook ThisWorkbook ThisWorkbook

Returns a Workbook object that represents the workbook where the current macro code is running.

(Inherited from _Application)

ThousandsSeparator ThousandsSeparator ThousandsSeparator

Sets or returns the character used for the thousands separator as a String.

(Inherited from _Application)

Toolbars Toolbars Toolbars

Reserved for internal use.

(Inherited from _Application)

Top Top Top

The distance, in points, from the top edge of the screen to the top edge of the main Microsoft Excel window. If the application window is minimized, this property controls the position of the window icon (anywhere on the screen).

(Inherited from _Application)

TransitionMenuKey TransitionMenuKey TransitionMenuKey

Returns or sets the Microsoft Excel menu or help key, which is usually "/".

(Inherited from _Application)

TransitionMenuKeyAction TransitionMenuKeyAction TransitionMenuKeyAction

Returns or sets the action taken when the Microsoft Excel menu key is pressed. Can be either xlExcelMenus or xlLotusHelp.

(Inherited from _Application)

TransitionNavigKeys TransitionNavigKeys TransitionNavigKeys

True if transition navigation keys are active.

(Inherited from _Application)

UILanguage UILanguage UILanguage

Reserved for internal use.

(Inherited from _Application)

UsableHeight UsableHeight UsableHeight

Returns the maximum height of the space that a window can occupy in the application window area, in points.

(Inherited from _Application)

UsableWidth UsableWidth UsableWidth

Returns the maximum width of the space that a window can occupy in the application window area in points.

(Inherited from _Application)

UseClusterConnector UseClusterConnector UseClusterConnector

Gets or sets whether Microsoft Excel allows user-defined functions in XLL add-ins to be run on a compute cluster.

(Inherited from _Application)

UsedObjects UsedObjects UsedObjects

Returns a UsedObjects object representing objects allocated in a workbook.

(Inherited from _Application)

UserControl UserControl UserControl

True if the application is visible or if it was created or started by the user. False if you created or started the application programmatically by using the CreateObject or GetObject functions and the application is hidden.

(Inherited from _Application)

UserLibraryPath UserLibraryPath UserLibraryPath

Returns the path to the location on the user’s computer where the COM add-ins are installed.

(Inherited from _Application)

UserName UserName UserName

Returns or sets the name of the current user.

(Inherited from _Application)

UseSystemSeparators UseSystemSeparators UseSystemSeparators

True (default) if the system separators of Microsoft Excel are enabled.

(Inherited from _Application)

Value Value Value

Returns "Microsoft Excel".

(Inherited from _Application)

VBE VBE VBE

Returns a VBE object that represents the Visual Basic Editor.

(Inherited from _Application)

Version Version Version

Returns the Microsoft Excel version number.

(Inherited from _Application)

Visible Visible Visible

Determines whether the object is visible.

(Inherited from _Application)

WarnOnFunctionNameConflict WarnOnFunctionNameConflict WarnOnFunctionNameConflict

The WarnOnFunctionNameConflict property, when set to True, raises an alert if a developer tries to create a new function using an existing function name. Read/write Boolean.

(Inherited from _Application)

Watches Watches Watches

Returns a Watches object representing a range which is tracked when the worksheet is recalculated.

(Inherited from _Application)

Width Width Width

The distance, in points, from the left edge of the application window to its right edge. If the window is minimized, this property is read-only and returns the width of the window icon.

(Inherited from _Application)

Windows Windows Windows

Returns a Windows collection that represents all the windows in all the workbooks.

(Inherited from _Application)

WindowsForPens WindowsForPens WindowsForPens

True if the computer is running under Microsoft Windows for Pen Computing.

(Inherited from _Application)

WindowState WindowState WindowState

Returns or sets the state of the window. Read/write XlWindowState.

(Inherited from _Application)

Workbooks Workbooks Workbooks

Returns a Workbooks collection that represents all the open workbooks.

(Inherited from _Application)

WorksheetFunction WorksheetFunction WorksheetFunction

Returns the WorksheetFunction object.

(Inherited from _Application)

Worksheets Worksheets Worksheets

Returns a Sheets collection that represents all the worksheets in the active workbook.

(Inherited from _Application)

_Default _Default _Default

Reserved for internal use.

(Inherited from _Application)

Methods

ActivateMicrosoftApp(XlMSApplication) ActivateMicrosoftApp(XlMSApplication) ActivateMicrosoftApp(XlMSApplication)

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(Object, String, Object) AddChartAutoFormat(Object, String, Object) AddChartAutoFormat(Object, String, Object)

Adds a custom chart autoformat to the list of available chart autoformats.

(Inherited from _Application)

AddCustomList(Object, Object) AddCustomList(Object, Object) AddCustomList(Object, Object)

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

(Inherited from _Application)

Calculate() Calculate() Calculate()

Calculates all open workbooks

(Inherited from _Application)

CalculateFull() CalculateFull() CalculateFull()

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

(Inherited from _Application)

CalculateFullRebuild() CalculateFullRebuild() CalculateFullRebuild()

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

(Inherited from _Application)

CalculateUntilAsyncQueriesDone() CalculateUntilAsyncQueriesDone() CalculateUntilAsyncQueriesDone()

Runs all pending queries to OLEDB and OLAP data sources.

(Inherited from _Application)

CentimetersToPoints(Double) CentimetersToPoints(Double) CentimetersToPoints(Double)

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

(Inherited from _Application)

CheckAbort(Object) CheckAbort(Object) CheckAbort(Object)

Stops recalculation in a Microsoft Excel application.

(Inherited from _Application)

CheckSpelling(String, Object, Object) CheckSpelling(String, Object, Object) CheckSpelling(String, Object, Object)

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(Object, XlReferenceStyle, Object, Object, Object) ConvertFormula(Object, XlReferenceStyle, Object, Object, Object) ConvertFormula(Object, XlReferenceStyle, Object, Object, Object)

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

(Inherited from _Application)

DDEExecute(Int32, String) DDEExecute(Int32, String) DDEExecute(Int32, String)

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

(Inherited from _Application)

DDEInitiate(String, String) DDEInitiate(String, String) DDEInitiate(String, String)

Opens a DDE channel to an application.

(Inherited from _Application)

DDEPoke(Int32, Object, Object) DDEPoke(Int32, Object, Object) DDEPoke(Int32, Object, Object)

Sends data to an application.

(Inherited from _Application)

DDERequest(Int32, String) DDERequest(Int32, String) DDERequest(Int32, String)

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

(Inherited from _Application)

DDETerminate(Int32) DDETerminate(Int32) DDETerminate(Int32)

Closes a channel to another application.

(Inherited from _Application)

DeleteChartAutoFormat(String) DeleteChartAutoFormat(String) DeleteChartAutoFormat(String)

Removes a custom chart autoformat from the list of available chart autoformats.

(Inherited from _Application)

DeleteCustomList(Int32) DeleteCustomList(Int32) DeleteCustomList(Int32)

Deletes a custom list.

(Inherited from _Application)

DisplayXMLSourcePane(Object) DisplayXMLSourcePane(Object) DisplayXMLSourcePane(Object)

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

(Inherited from _Application)

DoubleClick() DoubleClick() DoubleClick()

Equivalent to double-clicking the active cell.

(Inherited from _Application)

Dummy1(Object, Object, Object, Object) Dummy1(Object, Object, Object, Object) Dummy1(Object, Object, Object, Object)

Reserved for internal use.

(Inherited from _Application)

Dummy10(Object) Dummy10(Object) Dummy10(Object)

Reserved for internal use.

(Inherited from _Application)

Dummy11() Dummy11() Dummy11()

Reserved for internal use.

(Inherited from _Application)

Dummy12(PivotTable, PivotTable) Dummy12(PivotTable, PivotTable) Dummy12(PivotTable, PivotTable)

Reserved for internal use.

(Inherited from _Application)

Dummy13(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Dummy13(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Dummy13(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Reserved for internal use.

(Inherited from _Application)

Dummy14() Dummy14() Dummy14()

Reserved for internal use.

(Inherited from _Application)

Dummy2(Object, Object, Object, Object, Object, Object, Object, Object) Dummy2(Object, Object, Object, Object, Object, Object, Object, Object) Dummy2(Object, Object, Object, Object, Object, Object, Object, Object)

Reserved for internal use.

(Inherited from _Application)

Dummy20(Int32) Dummy20(Int32) Dummy20(Int32)

Reserved for internal use.

(Inherited from _Application)

Dummy3() Dummy3() Dummy3()

Reserved for internal use.

(Inherited from _Application)

Dummy4(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Dummy4(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Dummy4(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Reserved for internal use.

(Inherited from _Application)

Dummy5(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Dummy5(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Dummy5(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Reserved for internal use.

(Inherited from _Application)

Dummy6() Dummy6() Dummy6()

Reserved for internal use.

(Inherited from _Application)

Dummy7() Dummy7() Dummy7()

Reserved for internal use.

(Inherited from _Application)

Dummy8(Object) Dummy8(Object) Dummy8(Object)

Reserved for internal use.

(Inherited from _Application)

Dummy9() Dummy9() Dummy9()

Reserved for internal use.

(Inherited from _Application)

Evaluate(Object) Evaluate(Object) Evaluate(Object)

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

(Inherited from _Application)

ExecuteExcel4Macro(String) ExecuteExcel4Macro(String) ExecuteExcel4Macro(String)

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() FindFile() FindFile()

Displays the Open dialog box.

(Inherited from _Application)

GetCustomListContents(Int32) GetCustomListContents(Int32) GetCustomListContents(Int32)

Returns a custom list (an array of strings).

(Inherited from _Application)

GetCustomListNum(Object) GetCustomListNum(Object) GetCustomListNum(Object)

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(Object, Object, Object, Object, Object) GetOpenFilename(Object, Object, Object, Object, Object) GetOpenFilename(Object, Object, Object, Object, Object)

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

(Inherited from _Application)

GetPhonetic(Object) GetPhonetic(Object) GetPhonetic(Object)

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(Object, Object, Object, Object, Object) GetSaveAsFilename(Object, Object, Object, Object, Object) GetSaveAsFilename(Object, Object, Object, Object, Object)

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

(Inherited from _Application)

Goto(Object, Object) Goto(Object, Object) Goto(Object, Object)

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

(Inherited from _Application)

Help(Object, Object) Help(Object, Object) Help(Object, Object)

Displays a Help topic.

(Inherited from _Application)

InchesToPoints(Double) InchesToPoints(Double) InchesToPoints(Double)

Converts a measurement from inches to points.

(Inherited from _Application)

InputBox(String, Object, Object, Object, Object, Object, Object, Object) InputBox(String, Object, Object, Object, Object, Object, Object, Object) InputBox(String, Object, Object, Object, Object, Object, Object, Object)

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

(Inherited from _Application)

Intersect(Range, Range, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Intersect(Range, Range, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Intersect(Range, Range, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

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

(Inherited from _Application)

MacroOptions(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) MacroOptions(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) MacroOptions(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

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(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) MacroOptions2(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) MacroOptions2(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Reserved for internal use.

(Inherited from _Application)

MailLogoff() MailLogoff() MailLogoff()

Closes a MAPI mail session established by Microsoft Excel.

(Inherited from _Application)

MailLogon(Object, Object, Object) MailLogon(Object, Object, Object) MailLogon(Object, Object, Object)

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() NextLetter() 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(String, Object) OnKey(String, Object) OnKey(String, Object)

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

(Inherited from _Application)

OnRepeat(String, String) OnRepeat(String, String) OnRepeat(String, String)

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(Object, String, Object, Object) OnTime(Object, String, Object, Object) OnTime(Object, String, Object, Object)

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(String, String) OnUndo(String, String) OnUndo(String, String)

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() Quit() Quit()

Quits Microsoft Excel.

(Inherited from _Application)

RecordMacro(Object, Object) RecordMacro(Object, Object) RecordMacro(Object, Object)

Records code if the macro recorder is on.

(Inherited from _Application)

RegisterXLL(String) RegisterXLL(String) RegisterXLL(String)

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

(Inherited from _Application)

Repeat() Repeat() Repeat()

Repeats the last user interface action.

(Inherited from _Application)

ResetTipWizard() ResetTipWizard() 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(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Run(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Run(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Runs a macro or calls a function.

(Inherited from _Application)

Save(Object) Save(Object) Save(Object)

Saves changes to the specified workbook.

(Inherited from _Application)

SaveWorkspace(Object) SaveWorkspace(Object) SaveWorkspace(Object)

This object, member, or enumeration is deprecated and is not intended to be used in your code.

(Inherited from _Application)

SendKeys(Object, Object) SendKeys(Object, Object) SendKeys(Object, Object)

Sends keystrokes to the active application.

(Inherited from _Application)

SetDefaultChart(Object, Object) SetDefaultChart(Object, Object) SetDefaultChart(Object, Object)

Specifies the name of the chart template that Microsoft Excel will use when creating new charts.

(Inherited from _Application)

SharePointVersion(String) SharePointVersion(String) SharePointVersion(String)

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

(Inherited from _Application)

Support(Object, Int32, Object) Support(Object, Int32, Object) Support(Object, Int32, Object)

Reserved for internal use.

(Inherited from _Application)

Undo() Undo() Undo()

Cancels the last user interface action.

(Inherited from _Application)

Union(Range, Range, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Union(Range, Range, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Union(Range, Range, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Returns the union of two or more ranges.

(Inherited from _Application)

Volatile(Object) Volatile(Object) Volatile(Object)

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(Object) Wait(Object) Wait(Object)

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

(Inherited from _Application)

_Evaluate(Object) _Evaluate(Object) _Evaluate(Object)

Reserved for internal use.

(Inherited from _Application)

_FindFile() _FindFile() _FindFile()

Reserved for internal use.

(Inherited from _Application)

_Run2(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) _Run2(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) _Run2(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Reserved for internal use.

(Inherited from _Application)

_Wait(Object) _Wait(Object) _Wait(Object)

Reserved for internal use.

(Inherited from _Application)

_WSFunction(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) _WSFunction(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) _WSFunction(Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Reserved for internal use.

(Inherited from _Application)

Events

AfterCalculate AfterCalculate AfterCalculate

The AfterCalculate event occurs when all pending refresh activity (both synchronous and asynchronous) and all of the resultant calculation activities have been completed.

(Inherited from AppEvents_Event)

NewWorkbook NewWorkbook NewWorkbook

Occurs when a new workbook is created.

(Inherited from AppEvents_Event)

ProtectedViewWindowActivate ProtectedViewWindowActivate ProtectedViewWindowActivate

Occurs when a Protected View window is activated.

(Inherited from AppEvents_Event)

ProtectedViewWindowBeforeClose ProtectedViewWindowBeforeClose ProtectedViewWindowBeforeClose

Occurs immediately before a Protected View window or a workbook in a Protected View window closes.

(Inherited from AppEvents_Event)

ProtectedViewWindowBeforeEdit ProtectedViewWindowBeforeEdit ProtectedViewWindowBeforeEdit

Occurs immediately before editing is enabled on the workbook in the specified Protected View window.

(Inherited from AppEvents_Event)

ProtectedViewWindowDeactivate ProtectedViewWindowDeactivate ProtectedViewWindowDeactivate

Occurs when a Protected View window is deactivated.

(Inherited from AppEvents_Event)

ProtectedViewWindowOpen ProtectedViewWindowOpen ProtectedViewWindowOpen

Occurs when a workbook is opened in a Protected View window.

(Inherited from AppEvents_Event)

ProtectedViewWindowResize ProtectedViewWindowResize ProtectedViewWindowResize

Occurs when any Protected View window is resized.

(Inherited from AppEvents_Event)

SheetActivate SheetActivate SheetActivate

Occurs when any sheet is activated.

(Inherited from AppEvents_Event)

SheetBeforeDelete SheetBeforeDelete SheetBeforeDelete

Inherited from AppEvents_Event

SheetBeforeDoubleClick SheetBeforeDoubleClick SheetBeforeDoubleClick

Occurs when any worksheet is double-clicked, before the default double-click action.

(Inherited from AppEvents_Event)

SheetBeforeRightClick SheetBeforeRightClick SheetBeforeRightClick

Occurs when any worksheet is right-clicked, before the default right-click action.

(Inherited from AppEvents_Event)

SheetCalculate SheetCalculate SheetCalculate

Occurs after any worksheet is recalculated or after any changed data is plotted on a chart.

(Inherited from AppEvents_Event)

SheetChange SheetChange SheetChange

Occurs when cells in any worksheet are changed by the user or by an external link.

(Inherited from AppEvents_Event)

SheetDeactivate SheetDeactivate SheetDeactivate

Occurs when any sheet is deactivated.

(Inherited from AppEvents_Event)

Occurs when you click any hyperlink in Microsoft Excel.

(Inherited from AppEvents_Event)

SheetLensGalleryRenderComplete SheetLensGalleryRenderComplete SheetLensGalleryRenderComplete

Occurs after a callout gallery’s icons (dynamic and static) have finished rendering.

(Inherited from AppEvents_Event)

SheetPivotTableAfterValueChange SheetPivotTableAfterValueChange SheetPivotTableAfterValueChange

Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).

(Inherited from AppEvents_Event)

SheetPivotTableBeforeAllocateChanges SheetPivotTableBeforeAllocateChanges SheetPivotTableBeforeAllocateChanges

Occurs before changes are applied to a PivotTable.

(Inherited from AppEvents_Event)

SheetPivotTableBeforeCommitChanges SheetPivotTableBeforeCommitChanges SheetPivotTableBeforeCommitChanges

Occurs before changes are committed against the OLAP data source for a PivotTable.

(Inherited from AppEvents_Event)

SheetPivotTableBeforeDiscardChanges SheetPivotTableBeforeDiscardChanges SheetPivotTableBeforeDiscardChanges

Occurs before changes to a PivotTable are discarded.

(Inherited from AppEvents_Event)

SheetPivotTableUpdate SheetPivotTableUpdate SheetPivotTableUpdate

Occurs after the sheet of the PivotTable report has been updated.

(Inherited from AppEvents_Event)

SheetSelectionChange SheetSelectionChange SheetSelectionChange

Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).

(Inherited from AppEvents_Event)

SheetTableUpdate SheetTableUpdate SheetTableUpdate

Occurs when a table on a worksheet is updated.

(Inherited from AppEvents_Event)

WindowActivate WindowActivate WindowActivate

Occurs when any workbook window is activated.

(Inherited from AppEvents_Event)

WindowDeactivate WindowDeactivate WindowDeactivate

Occurs when any workbook window is deactivated.

(Inherited from AppEvents_Event)

WindowResize WindowResize WindowResize

Occurs when any workbook window is resized.

(Inherited from AppEvents_Event)

WorkbookActivate WorkbookActivate WorkbookActivate

Occurs when any workbook is activated.

(Inherited from AppEvents_Event)

WorkbookAddinInstall WorkbookAddinInstall WorkbookAddinInstall

Occurs when a workbook is installed as an add-in.

(Inherited from AppEvents_Event)

WorkbookAddinUninstall WorkbookAddinUninstall WorkbookAddinUninstall

Occurs when any add-in workbook is uninstalled.

(Inherited from AppEvents_Event)

WorkbookAfterSave WorkbookAfterSave WorkbookAfterSave

Occurs after the workbook is saved.

(Inherited from AppEvents_Event)

WorkbookAfterXmlExport WorkbookAfterXmlExport WorkbookAfterXmlExport

Occurs after Microsoft Excel saves or exports data from any open workbook to an XML data file.

(Inherited from AppEvents_Event)

WorkbookAfterXmlImport WorkbookAfterXmlImport WorkbookAfterXmlImport

Occurs after an existing XML data connection is refreshed or new XML data is imported into any open Microsoft Excel workbook.

(Inherited from AppEvents_Event)

WorkbookBeforeClose WorkbookBeforeClose WorkbookBeforeClose

Occurs immediately before any open workbook closes.

(Inherited from AppEvents_Event)

WorkbookBeforePrint WorkbookBeforePrint WorkbookBeforePrint

Occurs before any open workbook is printed.

(Inherited from AppEvents_Event)

WorkbookBeforeSave WorkbookBeforeSave WorkbookBeforeSave

Occurs before any open workbook is saved.

(Inherited from AppEvents_Event)

WorkbookBeforeXmlExport WorkbookBeforeXmlExport WorkbookBeforeXmlExport

Occurs before Microsoft Excel saves or exports data from any open workbook to an XML data file.

(Inherited from AppEvents_Event)

WorkbookBeforeXmlImport WorkbookBeforeXmlImport WorkbookBeforeXmlImport

Occurs before an existing XML data connection is refreshed or new XML data is imported into any open Microsoft Excel workbook.

(Inherited from AppEvents_Event)

WorkbookDeactivate WorkbookDeactivate WorkbookDeactivate

Occurs when any open workbook is deactivated.

(Inherited from AppEvents_Event)

WorkbookModelChange WorkbookModelChange WorkbookModelChange

Occurs when the data model is updated.

(Inherited from AppEvents_Event)

WorkbookNewChart WorkbookNewChart WorkbookNewChart

Occurs when a new chart is created in any open workbook.

(Inherited from AppEvents_Event)

WorkbookNewSheet WorkbookNewSheet WorkbookNewSheet

Occurs when a new sheet is created in any open workbook.

(Inherited from AppEvents_Event)

WorkbookOpen WorkbookOpen WorkbookOpen

Occurs when a workbook is opened.

(Inherited from AppEvents_Event)

WorkbookPivotTableCloseConnection WorkbookPivotTableCloseConnection WorkbookPivotTableCloseConnection

Occurs after a PivotTable report connection has been closed.

(Inherited from AppEvents_Event)

WorkbookPivotTableOpenConnection WorkbookPivotTableOpenConnection WorkbookPivotTableOpenConnection

Occurs after a PivotTablereport connection has been opened.

(Inherited from AppEvents_Event)

WorkbookRowsetComplete WorkbookRowsetComplete WorkbookRowsetComplete

The WorkbookRowsetCompleteevent occurs when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable.

(Inherited from AppEvents_Event)

WorkbookSync WorkbookSync WorkbookSync

Occurs when the local copy of a workbook that is part of a Document Workspace is synchronized with the copy on the server.

(Inherited from AppEvents_Event)

Applies to