| Application 对象 (Excel) | 您所在的位置：网站首页 › vba导出excel以对象方式的文件 › Application 对象 (Excel) |
|
Application 对象 (Excel)
项目
04/07/2023
代表整个 Microsoft Excel 应用程序。 示例Application 属性可用于返回 Application 对象。 下面的示例将 Windows 属性应用于 Application 对象。 Application.Windows("book1.xls").Activate下面的示例在其他应用程序中创建 Excel 工作簿对象，再在 Excel 中打开工作簿。 Set xl = CreateObject("Excel.Sheet") xl.Application.Workbooks.Open "newbook.xls"许多属性和方法都返回最常用的用户界面对象，如活动单元格（ActiveCell 属性）。无需添加 Application 对象限定符，即可使用这些属性和方法。 例如，无需编写 Application.ActiveCell.Font.Bold = True可以编写： ActiveCell.Font.Bold = True 注解Application 对象包括： 应用程序范围的设置和选项。 返回顶级对象（如 ActiveCell、ActiveSheet 等）的方法。 活动 AfterCalculate NewWorkbook ProtectedViewWindowActivate ProtectedViewWindowBeforeClose ProtectedViewWindowBeforeEdit ProtectedViewWindowDeactivate ProtectedViewWindowOpen ProtectedViewWindowResize SheetActivate SheetBeforeDelete SheetBeforeDoubleClick SheetBeforeRightClick SheetCalculate SheetChange SheetDeactivate SheetFollowHyperlink SheetLensGalleryRenderComplete SheetPivotTableAfterValueChange SheetPivotTableBeforeAllocateChanges SheetPivotTableBeforeCommitChanges SheetPivotTableBeforeDiscardChanges SheetPivotTableUpdate SheetSelectionChange SheetTableUpdate WindowActivate WindowDeactivate WindowResize WorkbookActivate WorkbookAddinInstall WorkbookAddinUninstall WorkbookAfterSave WorkbookAfterXmlExport WorkbookAfterXmlImport WorkbookBeforeClose WorkbookBeforePrint WorkbookBeforeSave WorkbookBeforeXmlExport WorkbookBeforeXmlImport WorkbookDeactivate WorkbookModelChange WorkbookNewChart WorkbookNewSheet WorkbookOpen WorkbookPivotTableCloseConnection WorkbookPivotTableOpenConnection WorkbookRowsetComplete WorkbookSync 方法 ActivateMicrosoftApp AddCustomList Calculate CalculateFull CalculateFullRebuild CalculateUntilAsyncQueriesDone CentimetersToPoints CheckAbort CheckSpelling ConvertFormula DDEExecute DDEInitiate DDEPoke DDERequest DDETerminate DeleteCustomList DisplayXMLSourcePane DoubleClick Evaluate ExecuteExcel4Macro FindFile GetCustomListContents GetCustomListNum GetOpenFilename GetPhonetic GetSaveAsFilename Goto Help InchesToPoints InputBox Intersect MacroOptions MailLogoff MailLogon NextLetter OnKey OnRepeat OnTime OnUndo Quit RecordMacro RegisterXLL Repeat Run SendKeys SharePointVersion Undo Union Volatile Wait 属性 ActiveCell ActiveChart ActiveEncryptionSession ActivePrinter ActiveProtectedViewWindow ActiveSheet ActiveWindow ActiveWorkbook AddIns AddIns2 AlertBeforeOverwriting AltStartupPath AlwaysUseClearType Application ArbitraryXMLSupportAvailable AskToUpdateLinks Assistance AutoCorrect AutoFormatAsYouTypeReplaceHyperlinks AutomationSecurity AutoPercentEntry AutoRecover Build CalculateBeforeSave Calculation CalculationInterruptKey CalculationState CalculationVersion Caller CanPlaySounds CanRecordSounds Caption CellDragAndDrop Cells ChartDataPointTrack Charts ClipboardFormats ClusterConnector Columns COMAddIns CommandBars CommandUnderlines ConstrainNumeric ControlCharacters CopyObjectsWithCells Creator Cursor CursorMovement CustomListCount CutCopyMode DataEntryMode DDEAppReturnCode DecimalSeparator DefaultFilePath DefaultSaveFormat DefaultSheetDirection DefaultWebOptions DeferAsyncQueries Dialogs DisplayAlerts DisplayClipboardWindow DisplayCommentIndicator DisplayDocumentActionTaskPane DisplayDocumentInformationPanel DisplayExcel4Menus DisplayFormulaAutoComplete DisplayFormulaBar DisplayFullScreen DisplayFunctionToolTips DisplayInsertOptions DisplayNoteIndicator DisplayPasteOptions DisplayRecentFiles DisplayScrollBars DisplayStatusBar EditDirectlyInCell EnableAnimations EnableAutoComplete EnableCancelKey EnableCheckFileExtensions EnableEvents EnableLargeOperationAlert EnableLivePreview EnableMacroAnimations EnableSound ErrorCheckingOptions Excel4IntlMacroSheets Excel4MacroSheets ExtendList FeatureInstall FileConverters FileDialog FileExportConverters FileValidation FileValidationPivot FindFormat FixedDecimal FixedDecimalPlaces FlashFill FlashFillMode FormulaBarHeight GenerateGetPivotData GenerateTableRefs Height HighQualityModeForGraphics Hinstance HinstancePtr Hwnd IgnoreRemoteRequests Interactive International IsSandboxed Iteration LanguageSettings LargeOperationCellThousandCount Left LibraryPath MailSession MailSystem MapPaperSize MathCoprocessorAvailable MaxChange MaxIterations MeasurementUnit MergeInstances MouseAvailable MoveAfterReturn MoveAfterReturnDirection MultiThreadedCalculation Name Names NetworkTemplatesPath NewWorkbook ODBCErrors ODBCTimeout OLEDBErrors OnWindow OperatingSystem OrganizationName Parent Path PathSeparator PivotTableSelection PreviousSelections PrintCommunication ProductCode PromptForSummaryInfo ProtectedViewWindows QuickAnalysis Range Ready RecentFiles RecordRelative ReferenceStyle RegisteredFunctions ReplaceFormat RollZoom Rows RTD ScreenUpdating Selection SensitivityLabelPolicy Sheets SheetsInNewWorkbook ShowChartTipNames ShowChartTipValues ShowDevTools ShowMenuFloaties ShowQuickAnalysis ShowSelectionFloaties ShowStartupDialog ShowToolTips SmartArtColors SmartArtLayouts SmartArtQuickStyles Speech SpellingOptions StandardFont StandardFontSize StartupPath StatusBar TemplatesPath ThisCell ThisWorkbook ThousandsSeparator Top TransitionMenuKey TransitionMenuKeyAction TransitionNavigKeys UsableHeight UsableWidth UseClusterConnector UsedObjects UserControl UserLibraryPath UserName UseSystemSeparators Value VBE Version Visible WarnOnFunctionNameConflict Watches Width Windows WindowsForPens WindowState Workbooks WorksheetFunction Worksheets 另请参阅 Excel 对象模型引用 支持和反馈有关于 Office VBA 或本文档的疑问或反馈？ 请参阅 Office VBA 支持和反馈，获取有关如何接收支持和提供反馈的指南。 |
| CopyRight 2018-2019 实验室设备网 版权所有 |