Application Properties

Vertex42 The Excel Nexus

Professional Excel Templates

Get Instant Access

Name

Returns

Description

ActiveCell

Range

Read-only. Returns the cell in the active sheet where the cursor is located

ActiveChart

Chart

Read-only. Returns the currently selected chart in the active workbook. If no chart is currently selected, nothing is returned

ActivePrinter

String

Set/Get the name of the printer currently being used

Name

Returns

Description

ActiveSheet

Object

Read-only. Returns the currently active sheet in the active workbook

ActiveWindow

Window

Read-only. Returns the currently selected Excel window, if any

ActiveWorkbook

Workbook

Read-only. Returns the workbook that is currently active, if any

AddIns

AddIns

Read-only. Returns the collection of Add-Ins currently available for use in Excel

AlertBefore Overwriting

Boolean

Set/Get whether a message pops up any time an attempt to overwrite non-blank cells by a drag-and-drop operation is made

AltStartupPath

String

Set/Get the alternative startup file location folder for Excel

AlwayUseClearType

Boolean

Set/Get the Boolean value determining whether ClearType is used to display fonts in menu, ribbon, and dialog box text

AnswerWizard Wizard

Answer

Read-only. Returns an object allowing manipulation of the Answer Wizard

ArbitraryXML

Support

Available

Boolean

Read-only. Returns a Boolean value indicating if the XML feature is available in Excel

AskToUpdate Links

Boolean

Set/Get whether the user is prompted to update links whenever a workbook with links is opened

Assistance

Assistant

Read-only. Returns an object representing the Microsoft Office Help Viewer

Assistant

Assistant

Read-only. Returns an object allowing manipulation of the Office Assistant

AutoCorrect

AutoCorrect

Read-only. Returns an object allowing modification of Excel's AutoCorrect features

AutoFormatAsYou

TypeReplace

Hyperlinks

Boolean

Set/Get whether Excel automatically formats/creates hyperlinks as you type

Automation Security Automation Security

Mso

Set/Get the level of macro security used when Excel opens a file programmatically

AutoPercent Entry

Boolean

Set/Get whether Excel automatically adds a % sign when typing a number into a cell that has a Percentage format applied

Name

Returns

Description

AutoRecover

AutoRecover

Set/Get AutoRecover options such as Path and Time interval

Build

Long

Read-only. Returns the exact build number of Excel

Calculate BeforeSave

Boolean

Set/Get whether workbooks are calculated before they are saved to disk. This assumes that formula calculation is not set to automatic (Calculation property)

Calculation

XlCalculation

Set/Get when calculations are made automatically, manually, or semi-automatically

Calculation InterruptKey Interrupt Key

XlCalculation

Set/Get the key that can interrupt Excel when performing calculations

Calculation

State

State

XlCalculation

Read-only. Indicates whether Excel calculations are in progress, pending, or done

Calculation Version

Long

Read-only. Returns the Excel version and calculation engine version used when the file was last saved

Caller

Variant

Read-only. Parameters: [Index]. Returns information describing what invoked the current Visual Basic code (for example, cell function, document event)

CanPlaySounds

Boolean

Read-only. Returns whether audio notes are heard in Excel. Property unused from Excel 2000 onward

CanRecord Sounds

Boolean

Read-only. Returns whether sound notes can be recorded in Excel. Property unused from Excel 2000 onward

Caption

String

Set/Get the caption that appears in the main Excel window

CellDragAnd Drop

Boolean

Set/Get whether dragging and dropping cells is possible

Cells

Range

Read-only. Returns all the cells in the active sheet

Charts

Sheets

Read-only. Returns all the charts in the active workbook

Name

Returns

Description

Clipboard Formats

Variant

Read-only. Parameters: [Index]. Returns an array of format values (XlClipboardFormat) that are currently in the clipboard

Columns

Range

Read-only. Returns all the columns in the currently active sheet

COMAddlns

COMAddIns

Read-only. Returns the collection of installed COM Add-Ins

CommandBars

CommandBars

Read-only. Returns the collection of command bars available to Excel

CommandUnderlines Underlines

XlCommand

Set/Get how commands are underlined in Excel. Used only on Macintosh systems

Constrain Numeric

Boolean

Set/Get whether only numbers and punctuation marks are recognized by handwriting recognition. Used only by Windows for Pen Computing

Control Characters

Boolean

Set/Get whether control characters are displayed for right-to-left languages. (Language support must be installed)

CopyObjects WithCells

Boolean

Set/Get whether objects (such as embedded objects) can be cut, copied, and sorted along with cell data

Cursor Pointer

XlMouse

Set/Get which mouse pointer is seen in Microsoft Excel

Cursor Movement

Long

Set/Get what type of cursor is used: visual or logical

CustomList Count

Long

Read-only. Returns the number of custom and built-in lists used in Excel (for example, Monday, Tuesday, Wednesday()

CutCopyMode

XlCutCopyMode

Set/Get whether a cut or copy operation is currently happening

DataEntryMode

Long

Set/Get whether locked cells can be edited (xlOff for editing allowed, xlOn for editing of unlocked cells only, xlStrict for editing of unlocked cells only that cannot be canceled by pressing Esc)

DDEAppReturnCode

Long

Read-only. Returns the result (confirmation/ error) of the last DDE message sent by Excel

DecimalSeparator

String

Set/Get the character used for the decimal separator. This is a global setting and will affect all workbooks when opened. Use Application UseSystemSeparators = True to globally reset custom separators

Name

Returns

Description

DefaultFile Path

String

Set/Get the default folder used when opening files

DefaultSave Format

XlFileFormat

Set/Get the default file format used when saving files

DefaultSheet Direction

Long

Set/Get which direction new sheets will appear in Excel

DefaultWeb

Options

Options

DefaultWeb

Read-only. Returns an object allowing manipulation of the items associated with the Web Options dialog box

Dialogs

Dialogs

Read-only. Returns a collection of all the built-in dialog boxes

DisplayAlerts

Boolean

Set/Get whether the user is prompted by typical Excel messages (for example, "Save Changes to Workbook?"), or no prompts appear and the default answer is always chosen

Display

Clipboard

Window

Boolean

Set/Get whether the Clipboard window is displayed. Used in Microsoft Office Macintosh Edition

Display Comment Indicator DisplayMode

XlComment

Set/Get how Excel displays cell comments and indicators

Display Document Action TaskPane

Boolean

Set to True to display the Document Actions task pane

DisplayDocument InformationPanel

Boolean

Set to True to display the Document Properties panel

DisplayExcel4 Menus

Boolean

Set/Get whether Excel displays Excel 4.0 menus

DisplayFormula AutoComplete

Boolean

Set to False to disable auto complete when entering formulas

DisplayFormulaBar

Boolean

Set/Get whether the formula bar is displayed

DisplayFullScreen

Boolean

Set/Get whether the Excel is in full-screen mode

DisplayFunction ToolTips

Boolean

Set/Get whether ToolTips for arguments appear in the cell when typing a function

Name

Returns

Description

DisplayInsert Options

Boolean

Set/Get whether the Insert Options drop-down button appears next to a range after inserting cells, rows, or columns

DisplayNote Indicator

Boolean

Set/Get whether comments inserted into cells have a little note indicator at the top-right corner of the cell

DisplayPaste Options

Boolean

Set/Get whether the Paste Options drop-down button appears next to a range after a paste operation. This is an Office XP setting and therefore affects all other Office applications that use this feature

DisplayRecent Files

Boolean

Set/Get whether the most recently opened files are displayed under the Office Icon in the upper left-hand corner of the application

DisplayScroll Bars

Boolean

Set/Get whether scrollbars are displayed for all open workbooks in the current session

Display StatusBar

Boolean

Set/Get whether the status bar is displayed

EditDirectly InCell

Boolean

Set/Get whether existing cell text can be modified directly in the cell. Note that cell text can still be overwritten directly

Enable Animations

Boolean

Set/Get whether adding and deleting cells, rows, and columns are animated

EnableAuto Complete

Boolean

Set/Get whether the AutoComplete feature is enabled

EnableKey CancelKey CancelKey

XlEnable

Set/Get how an Excel macro reacts when the user tries to interrupt the macro (for example, Ctrl+Break). This can be used to disable any user interruption, send any interruption to the error handler, or just stop the code (default). Use with care

EnableEvents

Boolean

Set/Get whether events are triggered for any object in the Excel object model that supports events

EnableLarge OperationAlerts

Boolean

Set to True to alert the user when an operation will affect the number of cells that exceeds the number specified in the Office center UI

EnableLivePreview

Boolean

Set/Get whether to show gallery previews

EnableSound

Boolean

Set/Get whether sounds are enabled for Excel

Name

Returns

Description

ErrorChecking Options

ErrorChecking Options

Set/Get error-checking properties such as BackgroundChecking, IndicatorColorIndex, and InconsistentFormula. These options mirror rules found in the Formulas section of the Excel Options dialog box

Excel4Intl MacroSheets

Sheets

Read-only. Returns the collection of sheets containing Excel 4 International macros

Excel4Macro Sheets

Sheets

Read-only. Returns the collection of sheets containing Excel 4 macros

ExtendList

Boolean

Set/Get whether formatting and formulas are automatically added when adding new rows or columns to the existing lists of rows or columns

Featurelnstall Install

MsoFeature

Set/Get how Excel reacts when an Excel feature is accessed that is not installed (through the interface or programmatically)

FileConverters

Variant

Read-only. Parameters: [Indexl], [Index2]. Returns an array of all the file converters available in Excel

FileDialog

FileDialog

Parameters: [fileDialogType] . Returns an object that represents an instance of one of several types of file dialog boxes

FileFind

IFind

Returns an object that can be used to search for files. Used in Microsoft Office Macintosh Edition

FindFormat

CellFormat

Set/Get search criteria for the types of cell formats to look for when using the Find and Replace methods

FixedDecimal

Boolean

Set/Get whether any numbers entered in the future will have the decimal points specified by FixedDecimalPlaces

FixedDecimal Places

Long

Set/Get the decimal places used for any future numbers

FormulaBarHeight

Long

Set/Get the height of the formula bar. The formula bar cannot exceed the viewable window height

GenerateGet PivotData

Boolean

Set/Get whether Excel can get PivotTable report data

GenerateTableRefs

Boolean

Determines whether the traditional notation method or the new structured referencing notation method is used for referencing tables in formulas

Name

Returns

Description

Height

Double

Set/Get the height of Excel's main application window. The value cannot be set if the main window is maximized or minimized

Hinstance

Long

Read-only. Returns the instance handle of the instance that is calling Excel. Used mainly by other custom applications like those written in Visual Basic

Hwnd

Long

Read-only. Returns the top-level window handle of the Excel window. Used mainly by other custom applications like those written in Visual Basic

IgnoreRemote Requests

Boolean

Set/Get whether remote requests through DDE are ignored

Interactive

Boolean

Set/Get whether Excel accepts keyboard and mouse input

International

Variant

Read-only. Parameters: [Index]. Returns international settings for Excel. Use the XlApplicationInternational constants as one of the values of Index

Iteration

Boolean

Set/Get whether Excel will iterate through and calculate all the cells in a circular reference trying to resolve the circular reference. Use with MaxIterations and MaxChange

Language Settings Settings

Language

Read-only. Returns an object describing the language settings in Excel

LargeOperation CellThousandCount

Long

Set/Get the maximum number of cells that can be affected by a given operation before triggering an alert

Left

Double

Set/Get the left edge of Excel's main application window. The value cannot be set if the main window is maximized or minimized

LibraryPath

String

Read-only. Returns the directory where Add-Ins are stored

MailSession

Variant

Read-only. Returns the hexadecimal mail session number or Null if mail session is active

MailSystem

XlMailSystem

Read-only. Returns what type of mail system is being used by the computer (for example, xlMapi, xlPowerTalk)

Name

Returns

Description

MapPaperSize

Boolean

Set/Get whether documents formatted for another country's/region's standard paper size (for example, A4) are automatically adjusted so that they're printed correctly on your country's/region's standard paper size (for example, Letter)

MathCoprocessor Available

Boolean

Read-only. Returns whether a math coprocessor is available

MaxChange

Double

Set/Get the minimum change between iterations of a circular reference before iterations stop

MaxIterations

Long

Set/Get the maximum number of iterations allowed for circular references before iterations stop

MeasurementUnit

xlMeasurement Unit

Set/Get the measurement unit used in the application with the xlMeasurementUnit constants

MouseAvailable

Boolean

Read-only. Returns whether the mouse is available

MoveAfter Return

Boolean

Set/Get whether the current cell changes when the user hits Enter

MoveAfter

Return

Direction

XlDirection

Set/Get which direction the cursor will move when the user hits Enter, changing the current cell

MultiThreaded

Calculation

Calculation

MultThreaded

Returns a MultThreadedCalculation object that controls the multi-threaded recalculation settings

Name

String

Read-only. Returns "Microsoft Excel"

Names

Names

Read-only. Returns the collection of defined names in an active workbook

NetworkTemplates Path

String

Read-only. Returns the location on the network where the Excel templates are kept, if any

NewWorkbook

NewFile

Returns a NewFile object

ODBCErrors

ODBCErrors

Read-only. Returns the collection of errors returned by the most recent query or Pivot-Table report that had an ODBC connection

ODBCTimeout

Long

Set/Get how long, in seconds, an ODBC connection will be kept before timing out

OLEDBErrors

OLEDBErrors

Read-only. Returns the collection of errors returned by the most recent query or Pivot-Table report that had an OLEDB connection

Name

Returns

Description

OnWindow

String

Set/Get the procedure that is executed every time a window is activated by the end user

Operating System

String

Read-only. Returns the name and version of the operating system

OrganizationName

String

Read-only. Returns the organization name as seen in the About Microsoft Excel dialog box

Path

String

Read-only. Returns the path where Excel is installed

PathSeparator

String

Read-only. Returns a backslash ("\") on a PC or a colon ":" on a Macintosh

PivotTable Selection

Boolean

Set/Get whether PivotTables use structured selection. For example, when selecting a Row field title, the associated data is selected with it

Previous Selections

Variant

Read-only. Parameters: [Index]. Returns an array of the last four ranges or named areas selected by using the Name dialog box or Goto feature

ProductCode

String

Read-only. Returns the GUID for Excel

PromptFor Summarylnfo

Boolean

Set/Get whether the user is prompted to enter summary information when trying to save a file

Range

Range

Read-only. Parameters: Celll, [Cell2]. Returns a Range object containing all the cells specified by the parameters

Ready

Boolean

Read-only. Determines whether the Excel application is ready

RecentFiles

RecentFiles

Read-only. Returns the collection of recently opened files

RecordRelative

Boolean

Read-only. Returns whether recorded macros use relative cell references (True) or absolute cell references (False)

ReferenceStyle Style

XlReference

Set/Get how cells are referenced: Letter-Number (for example, A1, A3) or RowNumber-ColumnNumber (for example, R1C1, R3C1)

Registered Functions

Variant

Read-only. Parameters: [Indexl], [Index2]. Returns the array of functions and function details relating to external DLLs or code resources. Using Add-Ins will add external DLLs to your workbook

Name

Returns

Description

ReplaceFormat

CellFormat

Set/Get replacement criteria for the types of cell formats to replace when using the Replace method

RollZoom

Boolean

Set/Get whether scrolling with a scroll mouse will zoom instead of scroll

Rows

Range

Read-only. Returns all the rows in the active sheet

RTD

RTD

Read-only. Returns a reference to a real-time date (RTD) object connected to an RTD Server

ScreenUpdating

Boolean

Set/Get whether Excel updates its display while a procedure is running. This property can be used to speed up procedure code by turning off screen updates (setting the property to False) during processing. Use with the ScreenRefresh method to manually refresh the screen

Selection

Object

Read-only. Returns whatever object is currently selected (for example, sheet, chart)

Sheets

Sheets

Read-only. Returns the collection of sheets in the active workbook

SheetslnNew Workbook

Long

Set/Get how many blank sheets are put in a newly created workbook

ShowChartTip Names

Boolean

Set/Get whether charts show the tip names over data points

ShowChartTip Values

Boolean

Set/Get whether charts show the tip values over data points

ShowDevTools

Boolean

Set to True to display the Developer tab

ShowMenuFloaties

Boolean

Set to False to disable mini-toolbars when right-clicking in the workbook window

ShowSelection Floaties

Boolean

Set to False to disable mini-toolbars when selecting text

ShowStartup Dialog

Boolean

Set/Get whether the New Workbook task pane appears when loading the Excel application

ShowToolTips

Boolean

Set/Get whether ToolTips are shown in Excel

ShowWindowsIn Taskbar

Boolean

Set/Get whether each workbook is visible on the taskbar (True) or only one Excel item is visible in the taskbar (False)

SmartTag

Recognizers

Recognizers

SmartTag

Read-only. Returns a collection of SmartTag recognition engines (recognizers) currently being used in the application

Name

Returns

Description

Speech

Speech

Read-only. Allows access to the properties and methods used to programmatically control the Office speech tools

Spelling

Options

Options

Spelling

Read-only. Allows access to the spelling options of the application

StandardFont

String

Set/Get what font is used as the standard Excel font

Standard FontSize

Double

Set/Get what font size is used as the standard Excel font size (in points)

StartupPath

String

Read-only. Returns the folder used as the Excel startup folder

StatusBar

Variant

Set/Get the status bar text. Returns False if Excel has control of the status bar. Set to False to give control of the status bar to Excel

TemplatesPath

String

Read-only. Returns the path to the Excel templates

ThisCell

Range

Set/Get the cell in which a user-defined function is being called

ThisWorkbook

Workbook

Read-only. Returns the workbook that contains the currently running VBA code

Thousands Separator

String

Set/Get the character used for the thousands separator. This is a global setting and will affect all workbooks when opened. Use Application UseSystemSeparators = True to globally reset custom separators

Top

Double

Set/Get the top of Excel's main application window. The value cannot be set if the main window is maximized or minimized

Transition MenuKey

String

Set/Get what key is used to bring up Excel's menu. The forward slash key ("/") is the default

Transition MenuKeyAction

Long

Set/Get what happens when the Transition Menu key is pressed. Either Excel menus appear (xlExcelMenu) or the Lotus Help dialog box (xlLotusHelp) appears

Transition NavigKeys

Boolean

Set/Get whether the Transition Navigation keys are active. These provide different key combinations for moving and selecting within a worksheet

UsableHeight

Double

Read-only. Returns the vertical space available in Excel's main window, in points, that is available to a sheet's Window. The value will be 1 if there is no space available

Name

Returns

Description

UsableWidth

Double

Read-only. Returns the horizontal space available in Excel's main window, in points, that is available to a sheet's Window. This property's value will be invalid if no space is available. Check the value of the UsableHeight property to check to see if there is any space available (>1)

UsedObjects

UsedObjects

Read-only. Represents objects allocated in a workbook

UseLegacy KeyboardShortcuts

Boolean

Set to True to enable the use of legacy keyboard shortcuts

UserControl

Boolean

Read-only. True if the current Excel session was started by a user, and False if the Excel session was started programmatically

UserLibraryPath

String

Read-only. Returns the location of Excel's COM Add-Ins

UserName

String

Set/Get the user name in Excel. Note that this is the name shown in the General tab of the Options dialog box, and not the current user's network ID or the name shown in the Excel splash screen

UseSystem Separators

Boolean

Set/Get whether the system operators in Excel are enabled. When set to False, you can use Application.DecimalSeparator and Application.ThousandsSeparator to override the system separators, which are located in the Regional Settings/Options applet in the Windows Control Panel

Value

String

Read-only. Returns "Microsoft Excel"

VBE

VBE

Read-only. Returns an object allowing manipulation of the Visual Basic Editor

Version

String

Read-only. Returns the version of Excel

Visible

Boolean

Set/Get whether Excel is visible to the user

WarnOnFunction NameConflict

Boolean

Set to True, this property raises an alert when a newly created function is given a name that duplicates an existing function name

Watches

Watches

Read-only. Returns a Watches object that represents all of the ranges that are tracked when a worksheet is calculated

Name

Returns

Description

Width

Windows

WindowState XlWindow

Workbooks

Worksheet

Function

Function

Worksheets

Double

Windows

WindowsForPens

Boolean xlWindowState

Workbooks

Worksheet

Sheets

Set/Get the width of Excel's main application window. The value cannot be set if the main window is maximized or minimized

Read-only. Returns all the Windows open in the current Excel session

Read-only. Returns whether Excel is running in a Windows for Pen Computing environment

Set/Get whether the window is maximized, minimized, or in a normal state

Read-only. Returns all the open workbooks (not including Add-Ins) in the current Excel session

Read-only. Returns an object holding all the Excel's worksheet functions that can be used in VBA

Read-only. Returns all the worksheets in the active workbook

Was this article helpful?

0 0
The Accidental Blogging Millionaires

The Accidental Blogging Millionaires

Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.

Get My Free Ebook


Post a comment