_Application Members

[このトピックはプレリリース版のため将来変更される可能性があります。また、プレースホルダとしてブランクのトピックが含まれています。]

Represents the entire Microsoft Excel application.

The following tables list the members exposed by the _Application type.

Public Properties

	Name	Description
	_Default
	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.
	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.
	ActiveDialog
	ActiveMenuBar
	ActivePrinter	Returns or sets the name of the active printer.
	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.
	ActiveWindow	Returns a Window object that represents the active window (the window on top). Returns Nothing if there are no windows open.
	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.
	AddIns	Returns an AddIns collection that represents all the add-ins listed in the Add-Ins dialog box (Tools menu).
	AlertBeforeOverwriting	True if Microsoft Excel displays a message before overwriting nonblank cells during a drag-and-drop editing operation.
	AltStartupPath	Returns or sets the name of the alternate startup folder.
	AnswerWizard	Returns the Microsoft.Office.Core.AnswerWizard object for Microsoft Excel.
	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).
	ArbitraryXMLSupportAvailable	Returns a Boolean value that indicates whether the XML features in Microsoft Excel are available.
	AskToUpdateLinks	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.
	Assistant	Returns an Microsoft.Office.Core.Assistant object for Microsoft Excel.
	AutoCorrect	Returns an AutoCorrect object that represents the Microsoft Excel AutoCorrect attributes.
	AutoFormatAsYouTypeReplaceHyperlinks	True (default) if Microsoft Excel automatically formats hyperlinks as you type. False if Excel does not automatically format hyperlinks as you type.
	AutomationSecurity	Returns or sets an Microsoft.Office.Core.MsoAutomationSecurity constant that represents the security mode Microsoft Excel uses when programmatically opening files.
	AutoPercentEntry	True if entries in cells formatted as percentages aren’t automatically multiplied by 100 as soon as they are entered.
	AutoRecover	Returns an AutoRecover object, which backs up all file formats on a timed interval.
	Build	Returns the Microsoft Excel build number.
	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.
	Calculation	Returns or sets the calculation mode. Read/write XlCalculation.
	CalculationInterruptKey	Sets or returns an XlCalculationInterruptKey constant that specifies the key that can interrupt Microsoft Excel when performing calculations.
	CalculationState	Returns an XlCalculationState constant that indicates the calculation state of the application for any calculations that are being performed in Microsoft Excel.
	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.
	Caller	Returns information about how Visual Basic was called (for more information, see the Remarks section).
	CanPlaySounds	This property should not be used. Sound notes have been removed from Microsoft Excel.
	CanRecordSounds	This property should not be used. Sound notes have been removed from Microsoft Excel.
	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".
	CellDragAndDrop	True if dragging and dropping cells is enabled.
	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.
	Charts	Returns a Sheets collection that represents all the chart sheets in the active workbook.
	ClipboardFormats	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.
	ColorButtons
	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.
	COMAddIns	Returns the Microsoft.Office.Core.COMAddIns collection for Microsoft Excel, which represents the currently installed COM add-ins.
	CommandBars	Returns a Microsoft.Office.Core.CommandBars object that represents the Microsoft Excel command bars.
	CommandUnderlines	Returns or sets the state of the command underlines in Microsoft Excel for the Macintosh.
	ConstrainNumeric	True if handwriting recognition is limited to numbers and punctuation only.
	ControlCharacters	True if Microsoft Excel displays control characters for right-to-left languages.
	CopyObjectsWithCells	True if objects are cut, copied, extracted, and sorted with cells.
	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.
	Cursor	Returns or sets the appearance of the mouse pointer in Microsoft Excel.
	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.
	CustomListCount	Returns the number of defined custom lists (including built-in lists).
	CutCopyMode	Returns or sets the status of Cut or Copy mode.
	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.
	DDEAppReturnCode	Returns the application-specific DDE return code that was contained in the last DDE acknowledge message received by Microsoft Excel.
	DecimalSeparator	Sets or returns the character used for the decimal separator as a String.
	DefaultFilePath	Returns or sets the default path that Microsoft Excel uses when it opens files.
	DefaultSaveFormat	Returns or sets the default format for saving files.
	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).
	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.
	Dialogs	Returns a Dialogs collection that represents all built-in dialog boxes.
	DialogSheets
	DisplayAlerts	True if Microsoft Excel displays certain alerts and messages while a macro is running.
	DisplayClipboardWindow	Returns True if the Microsoft Office Clipboard can be displayed.
	DisplayCommentIndicator	Returns or sets the way cells display comments and indicators. Can be one of the following XlCommentDisplayMode constants: xlNoIndicator, xlCommentIndicatorOnly, or xlCommentAndIndicator.
	DisplayDocumentActionTaskPane	Set to True to display the Document Actions task pane; set to False to hide the Document Actions task pane.
	DisplayExcel4Menus	True if Microsoft Excel displays version 4.0 menu bars.
	DisplayFormulaBar	True if the formula bar is displayed.
	DisplayFullScreen	True if Microsoft Excel is in full-screen mode.
	DisplayFunctionToolTips	True if function ToolTips can be displayed.
	DisplayInfoWindow
	DisplayInsertOptions	True if the Insert Options button should be displayed.
	DisplayNoteIndicator	True if cells containing notes display cell tips and contain note indicators (small dots in their upper-right corners).
	DisplayPasteOptions	True if the Paste Options button can be displayed.
	DisplayRecentFiles	True if the list of recently used files is displayed on the File menu.
	DisplayScrollBars	True if scroll bars are visible for all workbooks.
	DisplayStatusBar	True if the status bar is displayed.
	Dummy101
	EditDirectlyInCell	True if Microsoft Excel allows editing in cells.
	EnableAnimations	True if animated insertion and deletion is enabled.
	EnableAutoComplete	True if the AutoComplete feature is enabled.
	EnableCancelKey	Controls how Microsoft Excel handles CTRL+BREAK (or ESC or COMMAND+PERIOD) user interruptions to the running procedure. Read/write XlEnableCancelKey.
	EnableEvents	True if events are enabled for the specified object.
	EnableSound	True if sound is enabled for Microsoft Office.
	EnableTipWizard
	ErrorCheckingOptions	Returns an ErrorCheckingOptions object, which represents the error checking options for an application.
	Excel4IntlMacroSheets	Returns a Sheets collection that represents all the Microsoft Excel 4.0 international macro sheets in the specified workbook.
	Excel4MacroSheets	Returns a Sheets collection that represents all the Microsoft Excel 4.0 macro sheets in the specified workbook.
	ExtendList	True if Microsoft Excel automatically extends formatting and formulas to new data that is added to a list.
	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 Microsoft.Office.Core.MsoFeatureInstall.
	FileConverters	Returns information about installed file converters. Returns Null if there are no converters installed.
	FileDialog	Returns a Microsoft.Office.Core.FileDialog object representing an instance of the file dialog.
	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.
	FileSearch	Returns a Microsoft.Office.Core.FileSearch object for use with file searches. This property is available only in Microsoft Windows.
	FindFormat	Sets or returns the search criteria for the type of cell formats to find.
	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.
	FixedDecimalPlaces	Returns or sets the number of fixed decimal places used when the FixedDecimal property is set to True.
	GenerateGetPivotData	Returns True when Microsoft Excel can get PivotTable report data.
	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.
	Hinstance	Returns the instance handle of the instance that is calling Microsoft Excel.
	Hwnd	Returns an Integer indicating the top-level window handle of the Microsoft Excel window.
	IgnoreRemoteRequests	True if remote DDE requests are ignored.
	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.
	International	Returns information about the current country/region and international settings.
	Iteration	True if Microsoft Excel will use iteration to resolve circular references.
	LanguageSettings	Returns the Microsoft.Office.Core.LanguageSettings object, which contains information about the language settings in Microsoft Excel.
	LargeButtons
	Left	The distance, in points, from the left edge of the screen to the left edge of the main Microsoft Excel window.
	LibraryPath	Returns the path to the Library folder but without the final separator.
	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.
	MailSystem	Returns the mail system that's installed on the host machine. Read-only XlMailSystem.
	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.
	MathCoprocessorAvailable	True if a math coprocessor is available.
	MaxChange	Returns or sets the maximum amount of change between each iteration as Microsoft Excel resolves circular references.
	MaxIterations	Returns or sets the maximum number of iterations that Microsoft Excel can use to resolve a circular reference.
	MemoryFree	Returns the amount of memory that's still available for Microsoft Excel to use, in bytes.
	MemoryTotal
	MemoryUsed
	MenuBars
	Modules
	MouseAvailable	True if a mouse is available.
	MoveAfterReturn	True if the active cell will be moved as soon as the ENTER (RETURN) key is pressed.
	MoveAfterReturnDirection	Returns or sets the direction in which the active cell is moved when the user presses ENTER. Read/write XlDirection.
	Name	Returns the name of the object.
	Names	Returns a Names collection that represents all the names in the active workbook.
	NetworkTemplatesPath	Returns the network path where templates are stored. If the network path doesn’t exist, this property returns an empty string.
	NewWorkbook	Returns a NewFile object.
	ODBCErrors	Returns an ODBCErrors collection that contains all the ODBC errors generated by the most recent query table or PivotTable report operation.
	ODBCTimeout	Returns or sets the ODBC query time limit in seconds. The default value is 45 seconds.
	OLEDBErrors	Returns the OLEDBErrors collection, which represents the error information returned by the most recent OLE DB query.
	OnCalculate
	OnData
	OnDoubleClick
	OnEntry
	OnSheetActivate
	OnSheetDeactivate
	OnWindow	Returns or sets the name of the procedure that’s run whenever you activate a window.
	OperatingSystem	Returns the name and version number of the current operating system, for example, "Windows (32-bit) 4.00" or "Macintosh 7.00".
	OrganizationName	Returns the registered organization name.
	Parent	Returns the parent object for the specified object.
	Path	Returns the complete path to the application, excluding the final separator and name of the application.
	PathSeparator	Returns the path separator character ("\").
	PivotTableSelection	True if PivotTable reports use structured selection.
	PreviousSelections	Returns an array of the last four ranges or names selected. Each element in the array is a Range object.
	ProductCode	Returns the globally unique identifier (GUID) for Microsoft Excel.
	PromptForSummaryInfo	True if Microsoft Excel asks for summary information when files are first saved.
	Range	Returns a Range object that represents a cell or a range of cells.
	Ready	Returns True when the Microsoft Excel application is ready; False when the Excel application is not ready.
	RecentFiles	Returns a RecentFiles collection that represents the list of recently used files.
	RecordRelative	True if macros are recorded using relative references; False if recording is absolute.
	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.
	RegisteredFunctions	Returns information about functions in either dynamic-link libraries (DLLs) or code resources that were registered with the REGISTER or REGISTER.ID macro functions.
	ReplaceFormat	Sets the replacement criteria to use in replacing cell formats. The replacement criteria is then used in a subsequent call to the Replace method of the Range object.
	RollZoom	True if the IntelliMouse zooms instead of scrolling.
	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.
	RTD	Returns an RTD object.
	ScreenUpdating	True if screen updating is turned on.
	Selection	Returns the selected object in the active window.
	Sheets	Returns a Sheets collection that represents all the sheets in the active workbook.
	SheetsInNewWorkbook	Returns or sets the number of sheets that Microsoft Excel automatically inserts into new workbooks.
	ShortcutMenus
	ShowChartTipNames	True if charts show chart tip names. The default value is True.
	ShowChartTipValues	True if charts show chart tip values. The default value is True.
	ShowStartupDialog	Returns True (default) when the New Workbook task pane appears for a Microsoft Excel application.
	ShowToolTips	True if ToolTips are turned on.
	ShowWindowsInTaskbar	True if there’s a separate Windows taskbar button for each open workbook. The default value is True.
	SmartTagRecognizers	Returns a SmartTagRecognizers collection for an application.
	Speech	Returns a Speech object.
	SpellingOptions	Returns a SpellingOptions object that represents the spelling options of the application.
	StandardFont	Returns or sets the name of the standard font.
	StandardFontSize	Returns or sets the standard font size, in points.
	StartupPath	Returns the complete path of the startup folder excluding the final separator.
	StatusBar	Returns or sets the text in the status bar.
	TemplatesPath	Returns the local path where templates are stored.
	ThisCell	Returns the cell the user-defined function is being called from as a Range object.
	ThisWorkbook	Returns a Workbook object that represents the workbook where the current macro code is running.
	ThousandsSeparator	Sets or returns the character used for the thousands separator as a String.
	Toolbars
	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).
	TransitionMenuKey	Returns or sets the Microsoft Excel menu or help key, which is usually "/".
	TransitionMenuKeyAction	Returns or sets the action taken when the Microsoft Excel menu key is pressed. Can be either xlExcelMenus or xlLotusHelp.
	TransitionNavigKeys	True if transition navigation keys are active.
	UILanguage
	UsableHeight	Returns the maximum height of the space that a window can occupy in the application window area, in points.
	UsableWidth	Returns the maximum width of the space that a window can occupy in the application window area in points.
	UsedObjects	Returns a UsedObjects object representing objects allocated in a workbook.
	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.
	UserLibraryPath	Returns the path to the location on the user’s computer where the COM add-ins are installed.
	UserName	Returns or sets the name of the current user.
	UseSystemSeparators	True (default) if the system separators of Microsoft Excel are enabled.
	Value	Returns "Microsoft Excel".
	VBE	Returns a VBE object that represents the Visual Basic Editor.
	Version	Returns the Microsoft Excel version number.
	Visible	Determines whether the object is visible.
	Watches	Returns a Watches object representing a range which is tracked when the worksheet is recalculated.
	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.
	Windows	Returns a Windows collection that represents all the windows in all the workbooks.
	WindowsForPens	True if the computer is running under Microsoft Windows for Pen Computing.
	WindowState	Returns or sets the state of the window. Read/write XlWindowState.
	Workbooks	Returns a Workbooks collection that represents all the open workbooks.
	WorksheetFunction	Returns the WorksheetFunction object.
	Worksheets	Returns a Sheets collection that represents all the worksheets in the active workbook.

Top

Public Methods

	Name	Description
	_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.

Top

See Also

Reference

_Application Interface
Microsoft.Office.Interop.Excel Namespace