Application Object

Description

Represents the entire Microsoft Excel application. The Application object contains:

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

Use the Application property to return the Application object. The following example applies the Windows property to the Application object.

Application.Windows("book1.xls").Activate
The following example creates a Microsoft Excel worksheet object in another application and then opens a workbook in Microsoft Excel.

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

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. For example, instead of writing Application.ActiveCell.Font.Bold = True, you can write ActiveCell.Font.Bold = True.

Properties

ActiveCell property, ActiveChart property, ActivePrinter property, ActiveSheet property, ActiveWindow property, ActiveWorkbook property, AddIns property, AlertBeforeOverwriting property, AltStartupPath property, Application property, AskToUpdateLinks property, Assistant property, AutoCorrect property, Build property, CalculateBeforeSave property, Calculation property, Caller property, CanPlaySounds property, CanRecordSounds property, Caption property, CellDragAndDrop property, Cells property, Charts property, ClipboardFormats property, Columns property, CommandBars property, CommandUnderlines property, ConstrainNumeric property, ControlCharacters property, CopyObjectsWithCells property, Creator property, Cursor property, CursorMovement property, CustomListCount property, CutCopyMode property, DataEntryMode property, DDEAppReturnCode property, DefaultFilePath property, DefaultSaveFormat property, DefaultSheetDirection property, Dialogs property, DisplayAlerts property, DisplayClipboardWindow property, DisplayCommentIndicator property, DisplayExcel4Menus property, DisplayFormulaBar property, DisplayFullScreen property, DisplayNoteIndicator property, DisplayRecentFiles property, DisplayScrollBars property, DisplayStatusBar property, EditDirectlyInCell property, EnableAnimations property, EnableAutoComplete property, EnableCancelKey property, EnableEvents property, EnableSound property, Excel4IntlMacroSheets property, Excel4MacroSheets property, FileConverters property, FileFind property, FileSearch property, FixedDecimal property, FixedDecimalPlaces property, Height property, IgnoreRemoteRequests property, Interactive property, International property, Iteration property, Left property, LibraryPath property, MailSession property, MailSystem property, MathCoprocessorAvailable property, MaxChange property, MaxIterations property, MemoryFree property, MemoryTotal property, MemoryUsed property, MouseAvailable property, MoveAfterReturn property, MoveAfterReturnDirection property, Name property, Names property, NetworkTemplatesPath property, ODBCErrors property, ODBCTimeout property, OnWindow property, OperatingSystem property, OrganizationName property, Parent property, Path property, PathSeparator property, PivotTableSelection property, PreviousSelections property, PromptForSummaryInfo property, Range property (Application, Range, or Worksheet object), RecentFiles property, RecordRelative property, ReferenceStyle property, RegisteredFunctions property, RollZoom property, Rows property, ScreenUpdating property, Selection property, Sheets property, SheetsInNewWorkbook property, ShowChartTipNames property, ShowChartTipValues property, ShowToolTips property, StandardFont property, StandardFontSize property, StartupPath property, StatusBar property, TemplatesPath property, ThisWorkbook property, Top property, TransitionMenuKey property, TransitionMenuKeyAction property, TransitionNavigKeys property, UILanguage property, UsableHeight property, UsableWidth property, UserControl property, UserName property, Value property, VBE property, Version property, Visible property, Width property, Windows property, WindowsForPens property, WindowState property, Workbooks property, WorksheetFunction property, Worksheets property.

Methods

ActivateMicrosoftApp method, AddChartAutoFormat method, AddCustomList method, Calculate method, CentimetersToPoints method, CheckSpelling method, ConvertFormula method, DDEExecute method, DDEInitiate method, DDEPoke method, DDERequest method, DDETerminate method, DeleteChartAutoFormat method, DeleteCustomList method, DoubleClick method, Evaluate method, ExecuteExcel4Macro method, FindFile method, GetCustomListContents method, GetCustomListNum method, GetOpenFilename method, GetSaveAsFilename method, Goto method, Help method, InchesToPoints method, InputBox method, Intersect method, MacroOptions method, MailLogoff method, MailLogon method, NextLetter method, OnKey method, OnRepeat method, OnTime method, OnUndo method, Quit method, RecordMacro method, RegisterXLL method, Repeat method, Run method, SaveWorkspace method, SendKeys method, SetDefaultChart method, Undo method, Union method, Volatile method, Wait method.

Events

NewWorkbook event, SheetActivate event, SheetBeforeDoubleClick event, SheetBeforeRightClick event, SheetCalculate event, SheetChange event, SheetDeactivate event, SheetSelectionChange event, WindowActivate event, WindowDeactivate event, WindowResize event, WorkbookActivate event, WorkbookAddinInstall event, WorkbookAddinUninstall event, WorkbookBeforeClose event, WorkbookBeforePrint event, WorkbookBeforeSave event, WorkbookDeactivate event, WorkbookNewSheet event, WorkbookOpen event.