Properties and Methods of the Application Object

The Application object has a whopping 268 properties and methods, shown in Table 16-1.

Table 16-1. Application object members^

_Default

DisplayRecentFiles

OnDoubleClick

_Evaluate

DisplayScrollBars

OnEntry

_FindFile<v9>

DisplayStatusBar

OnKey

_Run2

DoubleClick

OnRepeat

_Wait<v9>

Dummy 1

OnSheetActivate

_WSFunction

Dummy 10

OnSheetDeactivate

ActivateMicrosoftApp

Dummy 101 <v9>

OnTime

ActiveCell

Dummy 11

OnUndo

ActiveChart

Dummy 12<v9>

On Window

ActiveDialog

Dummy 13 <v 10>

Operating System

ActiveMenuB ar

Dummy 14<v10>

OrganizationName

ActivePrinter

Dummy2

Parent

Active Sheet

Dummy3

Path

Active Window

Dummy4

PathSeparator

Active Workbook

Dummy5

PivotTableSelection

AddChartAutoFormat

Dummy6

Previous Selections

AddCustomList

Dummy7

ProductCode<v9>

AddIns

Dummy8

PromptForSummarylnfo

AlertBeforeOverwriting

Dummy9

Quit

AltStartupPath

EditDirectlylnCell

Range

AnswerWizard<v9>

EnableAnimations

Ready<v10>

Application

EnableAutoComplete

RecentFiles

AskToUpdateLinks

EnableCancelKey

RecordMacro

Assistant

EnableEvents

RecordRelative

AutoCorrect

EnableSound

ReferenceStyle

AutoFormatAsYouTypeReplaceHyperlinks<v 10>

EnableTip Wizard

RegisteredFunctions

AutomationSecurity<v10>

ErrorCheckingOptions<v10>

RegisterXLL

AutoPercentEntry<v9>

Evaluate

Repeat

AutoRecover<v 10>

Excel4IntlMacroSheets

ReplaceFormat<v10>

Build

Excel4Macro Sheets

ResetTip Wizard

Calculate

ExecuteExcel4Macro

RollZoom

CalculateBeforeSave

ExtendList<v9>

Rows

CalculateFull<v9>

FeatureInstall<v9>

RTD<v10>

CalculateFullRebuild<v 10>

FileConverters

Run

Calculation

FileDialog<v10>

Save

CalculationInterruptKey<v 10>

FileFind

SaveWorkspace

CalculationState<v10>

FileSearch

ScreenUpdating

Calculation Version<v9>

FindFile

Selection

Caller

FindFormat<v 10>

SendKeys

CanPlaySounds

FixedDecimal

SetDefaultChart

CanRecordSounds

FixedDecimalPlaces

Sheets

Caption

GenerateGetPivotData<v 10>

SheetslnNewWorkbook

CellDragAndDrop

GetCustomListContents

ShortcutMenus

Cells

GetCustomListNum

ShowChartTipNames

CentimetersToPoints

GetOpenFilename

ShowChartTipValues

Charts

GetPhonetic<v9>

ShowStartupDialog<v 10>

CheckAbort<v 10>

GetSaveAsFilename

ShowToolTips

CheckSpelling

Goto

ShowWindowsInTaskbar<v9>

ClipboardFormats

Height

SmartTagRecognizers<v10>

ColorButtons

Help

Speech<v10>

Columns

Hinstance<v10>

SpellingOptions<v 10>

COMAddIns<v9>

Hwnd<v10>

StandardFont

CommandBars

IgnoreRemoteRequests

StandardFontSize

CommandUnderlines

InchesToPoints

StartupPath

ConstrainNumeric

InputBox

StatusBar

ControlCharacters

Interactive

TemplatesPath

ConvertFormula

International

ThisCell<v10>

CopyObj ects WithCells

Intersect

ThisWorkbook

Creator

Iteration

Thous ands Separator<v 10>

Cursor

LanguageSettings<v9>

Toolbars

CursorMovement

LargeButtons

Top

CustomListCount

Left

TransitionMenuKey

CutCopyMode

LibraryPath

TransitionMenuKeyAction

DataEntryMode

MacroOptions

TransitionNavigKeys

DDEAppReturnCode

MailLogoff

UILanguage

DDEExecute

MailLogon

Undo

DDEInitiate

MailSession

Union

DDEPoke

MailSystem

UsableHeight

DDERequest

MapPaperSize<v10>

UsableWidth

DDETerminate

MathCoprocessorAvailable

UsedObj ects<v 10>

DecimalSeparator<v 10>

MaxChange

UserControl

DefaultFilePath

MaxIterations

UserLibraryPath<v9>

DefaultSaveFormat

MemoryFree

UserName

DefaultSheetDirection

MemoryTotal

UseSystemSeparators<v10>

DefaultWebOptions<v9>

MemoryUsed

Value

DeleteChartAutoFormat

MenuBars

VBE

DeleteCustomList

Modules

Version

Dialogs

MouseAvailable

Visible

Dialog Sheets

MoveAfterReturn

Volatile

DisplayAlerts

MoveAfterReturnDirection

Wait

DisplayClipboardWindow

Name

Watches<v10>

DisplayCommentlndicator

Names

Width

DisplayExcel4Menus

NetworkTemplatesPath

Windows

DisplayFormulaBar

NewWorkbook<v 10>

WindowsForPens

DisplayFullScreen

NextLetter

WindowState

DisplayFunctionToolTips<v10>

ODBCErrors

Workbooks

Displaylnfo Window

ODBCTimeout

WorksheetFunction

DisplayInsertOptions<v 10>

OLEDBErrors<v9>

Worksheets

DisplayNotelndicator

OnCalculate

DisplayPasteOptions<v10>

OnData

1' (g) indicates a global member.

Of course, there are far too many members to discuss even the majority in a nonreference book, so we will pick out a few of the more interesting and useful members. The important point is that you can use Table 16-1 to find a member that suits a particular purpose and then check the Excel help files for more information if it is not covered in this book.

We will also discuss additional properties and methods of the Application object throughout the remainder of the book, hopefully at times when the discussion will be more relevant.

In the hope of making our discussion a bit more structured, we will try to break the members in Table 16-1 into separate groups. Note, however, that this is in many cases a bit arbitrary.

0 0

Post a comment