Application-Objekt (Excel)Application object (Excel)

Stellt die gesamte Microsoft Excel-Anwendung dar.Represents the entire Microsoft Excel application.

BeispielExample

Verwenden Sie die Anwendung Eigenschaft, um das Application -Objekt zurückzugeben.Use the Application property to return the Application object. Im folgende Beispiel gilt die Windows -Eigenschaft für das Application -Objekt.The following example applies the Windows property to the Application object.

Application.Windows("book1.xls").Activate

Im folgenden Beispiel wird ein Excel-Arbeitsmappenobjekt in einer anderen Anwendung erstellt und anschließend eine Arbeitsmappe in Excel geöffnet.The following example creates an Excel workbook object in another application and then opens a workbook in Excel.

Set xl = CreateObject("Excel.Sheet") 
xl.Application.Workbooks.Open "newbook.xls"

Viele der Eigenschaften und Methoden, die am häufigsten verwendeten Benutzeroberflächen-Objekte, wie die aktive Zelle (ActiveCell -Eigenschaft), zurückgeben, können ohne Objektkennzeichner Application verwendet werden.Many of the properties and methods that return the most common user-interface objects, such as the active cell (ActiveCell property), can be used without the Application object qualifier. Beispielsweise anstelle von:For example, instead of writing:

Application.ActiveCell.Font.Bold = True

Sie können Folgendes schreiben:You can write:

ActiveCell.Font.Bold = True

HinweiseRemarks

Das Application -Objekt enthält:The Application object contains:

  • Anwendungsweite Einstellungen und Optionen.Application-wide settings and options.

  • Methoden, die Objekte der obersten Ebene zurückgeben wie ActiveCell, ActiveSheet usw.Methods that return top-level objects, such as ActiveCell, ActiveSheet, and so on.

EreignisseEvents

NameName
AfterCalculateAfterCalculate
NewWorkbookNewWorkbook
ProtectedViewWindowActivateProtectedViewWindowActivate
ProtectedViewWindowBeforeCloseProtectedViewWindowBeforeClose
ProtectedViewWindowBeforeEditProtectedViewWindowBeforeEdit
ProtectedViewWindowDeactivateProtectedViewWindowDeactivate
ProtectedViewWindowOpenProtectedViewWindowOpen
ProtectedViewWindowResizeProtectedViewWindowResize
SheetActivateSheetActivate
SheetBeforeDeleteSheetBeforeDelete
SheetBeforeDoubleClickSheetBeforeDoubleClick
SheetBeforeRightClickSheetBeforeRightClick
SheetCalculateSheetCalculate
SheetChangeSheetChange
SheetDeactivateSheetDeactivate
SheetFollowHyperlinkSheetFollowHyperlink
SheetLensGalleryRenderCompleteSheetLensGalleryRenderComplete
SheetPivotTableAfterValueChangeSheetPivotTableAfterValueChange
SheetPivotTableBeforeAllocateChangesSheetPivotTableBeforeAllocateChanges
SheetPivotTableBeforeCommitChangesSheetPivotTableBeforeCommitChanges
SheetPivotTableBeforeDiscardChangesSheetPivotTableBeforeDiscardChanges
SheetPivotTableUpdateSheetPivotTableUpdate
SheetSelectionChangeSheetSelectionChange
SheetTableUpdateSheetTableUpdate
WindowActivateWindowActivate
WindowDeactivateWindowDeactivate
WindowResizeWindowResize
WorkbookActivateWorkbookActivate
WorkbookAddinInstallWorkbookAddinInstall
WorkbookAddinUninstallWorkbookAddinUninstall
WorkbookAfterSaveWorkbookAfterSave
WorkbookAfterXmlExportWorkbookAfterXmlExport
WorkbookAfterXmlImportWorkbookAfterXmlImport
WorkbookBeforeCloseWorkbookBeforeClose
WorkbookBeforePrintWorkbookBeforePrint
WorkbookBeforeSaveWorkbookBeforeSave
WorkbookBeforeXmlExportWorkbookBeforeXmlExport
WorkbookBeforeXmlImportWorkbookBeforeXmlImport
WorkbookDeactivateWorkbookDeactivate
WorkbookModelChangeWorkbookModelChange
WorkbookNewChartWorkbookNewChart
WorkbookNewSheetWorkbookNewSheet
WorkbookOpenWorkbookOpen
WorkbookPivotTableCloseConnectionWorkbookPivotTableCloseConnection
WorkbookPivotTableOpenConnectionWorkbookPivotTableOpenConnection
WorkbookRowsetCompleteWorkbookRowsetComplete
WorkbookSyncWorkbookSync

MethodenMethods

NameName
ActivateMicrosoftAppActivateMicrosoftApp
AddCustomListAddCustomList
CalculateCalculate
CalculateFullCalculateFull
CalculateFullRebuildCalculateFullRebuild
CalculateUntilAsyncQueriesDoneCalculateUntilAsyncQueriesDone
CentimetersToPointsCentimetersToPoints
CheckAbortCheckAbort
CheckSpellingCheckSpelling
ConvertFormulaConvertFormula
DDEExecuteDDEExecute
DDEInitiateDDEInitiate
DDEPokeDDEPoke
DDERequestDDERequest
DDETerminateDDETerminate
DeleteCustomListDeleteCustomList
DisplayXMLSourcePaneDisplayXMLSourcePane
DoubleClickDoubleClick
EvaluateEvaluate
ExecuteExcel4MacroExecuteExcel4Macro
FindFileFindFile
GetCustomListContentsGetCustomListContents
GetCustomListNumGetCustomListNum
GetOpenFilenameGetOpenFilename
GetPhoneticGetPhonetic
GetSaveAsFilenameGetSaveAsFilename
Gehe zuGoto
HilfeHelp
InchesToPointsInchesToPoints
InputBoxInputBox
IntersectIntersect
MacroOptionsMacroOptions
MailLogoffMailLogoff
MailLogonMailLogon
NextLetterNextLetter
OnKeyOnKey
OnRepeatOnRepeat
OnTimeOnTime
OnUndoOnUndo
QuitQuit
RecordMacroRecordMacro
RegisterXLLRegisterXLL
RepeatRepeat
RunRun
SendKeysSendKeys
SharePointVersionSharePointVersion
UndoUndo
UnionUnion
VolatileVolatile
WaitWait

EigenschaftenProperties

NameName
ActiveCellActiveCell
ActiveChartActiveChart
ActiveEncryptionSessionActiveEncryptionSession
ActivePrinterActivePrinter
ActiveProtectedViewWindowActiveProtectedViewWindow
ActiveSheetActiveSheet
ActiveWindowActiveWindow
ActiveWorkbookActiveWorkbook
Add-InsAddIns
AddIns2AddIns2
AlertBeforeOverwritingAlertBeforeOverwriting
AltStartupPathAltStartupPath
AlwaysUseClearTypeAlwaysUseClearType
ApplicationApplication
ArbitraryXMLSupportAvailableArbitraryXMLSupportAvailable
AskToUpdateLinksAskToUpdateLinks
AssistanceAssistance
AutoCorrectAutoCorrect
AutoFormatAsYouTypeReplaceHyperlinksAutoFormatAsYouTypeReplaceHyperlinks
AutomationSecurityAutomationSecurity
AutoPercentEntryAutoPercentEntry
AutoRecoverAutoRecover
Erstellen vonBuild
CalculateBeforeSaveCalculateBeforeSave
CalculationCalculation
CalculationInterruptKeyCalculationInterruptKey
CalculationStateCalculationState
CalculationVersionCalculationVersion
CallerCaller
CanPlaySoundsCanPlaySounds
CanRecordSoundsCanRecordSounds
BeschriftungCaption
CellDragAndDropCellDragAndDrop
ZellenCells
ChartDataPointTrackChartDataPointTrack
ChartsCharts
ClipboardFormatsClipboardFormats
ClusterConnectorClusterConnector
ColumnsColumns
COMAddInsCOMAddIns
CommandBarsCommandBars
CommandUnderlinesCommandUnderlines
ConstrainNumericConstrainNumeric
ControlCharactersControlCharacters
CopyObjectsWithCellsCopyObjectsWithCells
CreatorCreator
CursorCursor
CursorMovementCursorMovement
CustomListCountCustomListCount
CutCopyModeCutCopyMode
DataEntryModeDataEntryMode
DDEAppReturnCodeDDEAppReturnCode
DecimalSeparatorDecimalSeparator
DefaultFilePathDefaultFilePath
DefaultSaveFormatDefaultSaveFormat
DefaultSheetDirectionDefaultSheetDirection
DefaultWebOptionsDefaultWebOptions
DeferAsyncQueriesDeferAsyncQueries
DialogsDialogs
DisplayAlertsDisplayAlerts
DisplayClipboardWindowDisplayClipboardWindow
DisplayCommentIndicatorDisplayCommentIndicator
DisplayDocumentActionTaskPaneDisplayDocumentActionTaskPane
DisplayDocumentInformationPanelDisplayDocumentInformationPanel
DisplayExcel4MenusDisplayExcel4Menus
DisplayFormulaAutoCompleteDisplayFormulaAutoComplete
DisplayFormulaBarDisplayFormulaBar
DisplayFullScreenDisplayFullScreen
DisplayFunctionToolTipsDisplayFunctionToolTips
DisplayInsertOptionsDisplayInsertOptions
DisplayNoteIndicatorDisplayNoteIndicator
DisplayPasteOptionsDisplayPasteOptions
DisplayRecentFilesDisplayRecentFiles
DisplayScrollBarsDisplayScrollBars
DisplayStatusBarDisplayStatusBar
EditDirectlyInCellEditDirectlyInCell
EnableAnimationsEnableAnimations
EnableAutoCompleteEnableAutoComplete
EnableCancelKeyEnableCancelKey
EnableCheckFileExtensionsEnableCheckFileExtensions
EnableEventsEnableEvents
EnableLargeOperationAlertEnableLargeOperationAlert
EnableLivePreviewEnableLivePreview
EnableMacroAnimationsEnableMacroAnimations
EnableSoundEnableSound
ErrorCheckingOptionsErrorCheckingOptions
Excel4IntlMacroSheetsExcel4IntlMacroSheets
Excel4MacroSheetsExcel4MacroSheets
ExtendListExtendList
FeatureInstallFeatureInstall
FileConvertersFileConverters
FileDialogFileDialog
FileExportConvertersFileExportConverters
FileValidationFileValidation
FileValidationPivotFileValidationPivot
FindFormatFindFormat
FixedDecimalFixedDecimal
FixedDecimalPlacesFixedDecimalPlaces
FlashFillFlashFill
FlashFillModeFlashFillMode
FormulaBarHeightFormulaBarHeight
GenerateGetPivotDataGenerateGetPivotData
GenerateTableRefsGenerateTableRefs
HeightHeight
HighQualityModeForGraphicsHighQualityModeForGraphics
HinstanceHinstance
HinstancePtrHinstancePtr
HwndHwnd
IgnoreRemoteRequestsIgnoreRemoteRequests
InteractiveInteractive
InternationalInternational
IsSandboxedIsSandboxed
IterationIteration
LanguageSettingsLanguageSettings
LargeOperationCellThousandCountLargeOperationCellThousandCount
LeftLeft
LibraryPathLibraryPath
MailSessionMailSession
MailSystemMailSystem
MapPaperSizeMapPaperSize
MathCoprocessorAvailableMathCoprocessorAvailable
MaxChangeMaxChange
MaxIterationsMaxIterations
MeasurementUnitMeasurementUnit
MergeInstancesMergeInstances
MouseAvailableMouseAvailable
MoveAfterReturnMoveAfterReturn
MoveAfterReturnDirectionMoveAfterReturnDirection
MultiThreadedCalculationMultiThreadedCalculation
NameName
NamesNames
NetworkTemplatesPathNetworkTemplatesPath
NewWorkbookNewWorkbook
ODBCErrorsODBCErrors
ODBCTimeoutODBCTimeout
OLEDBErrorsOLEDBErrors
OnWindowOnWindow
OperatingSystemOperatingSystem
OrganizationNameOrganizationName
ParentParent
PathPath
PathSeparatorPathSeparator
PivotTableSelectionPivotTableSelection
PreviousSelectionsPreviousSelections
PrintCommunicationPrintCommunication
ProductCodeProductCode
PromptForSummaryInfoPromptForSummaryInfo
ProtectedViewWindowsProtectedViewWindows
QuickAnalysisQuickAnalysis
RangeRange
ReadyReady
RecentFilesRecentFiles
RecordRelativeRecordRelative
ReferenceStyleReferenceStyle
RegisteredFunctionsRegisteredFunctions
ReplaceFormatReplaceFormat
RollZoomRollZoom
RowsRows
RTDRTD
ScreenUpdatingScreenUpdating
SelectionSelection
SheetsSheets
SheetsInNewWorkbookSheetsInNewWorkbook
ShowChartTipNamesShowChartTipNames
ShowChartTipValuesShowChartTipValues
ShowDevToolsShowDevTools
ShowMenuFloatiesShowMenuFloaties
ShowQuickAnalysisShowQuickAnalysis
ShowSelectionFloatiesShowSelectionFloaties
ShowStartupDialogShowStartupDialog
ShowToolTipsShowToolTips
SmartArtColorsSmartArtColors
SmartArtLayoutsSmartArtLayouts
SmartArtQuickStylesSmartArtQuickStyles
SpeechSpeech
SpellingOptionsSpellingOptions
StandardFontStandardFont
StandardFontSizeStandardFontSize
StartupPathStartupPath
StatusBarStatusBar
TemplatesPathTemplatesPath
ThisCellThisCell
ThisWorkbookThisWorkbook
ThousandsSeparatorThousandsSeparator
TopTop
TransitionMenuKeyTransitionMenuKey
TransitionMenuKeyActionTransitionMenuKeyAction
TransitionNavigKeysTransitionNavigKeys
UsableHeightUsableHeight
UsableWidthUsableWidth
UseClusterConnectorUseClusterConnector
UsedObjectsUsedObjects
UserControlUserControl
UserLibraryPathUserLibraryPath
UserNameUserName
UseSystemSeparatorsUseSystemSeparators
WertValue
VBEVBE
VersionVersion
VisibleVisible
WarnOnFunctionNameConflictWarnOnFunctionNameConflict
WatchesWatches
WidthWidth
WindowsWindows
WindowsForPensWindowsForPens
WindowStateWindowState
ArbeitsmappenWorkbooks
WorksheetFunctionWorksheetFunction
WorksheetsWorksheets

Siehe auchSee also