VBA supported Data Model

%PRODUCTNAME Basic adds this set of functionalies when VBA Office support is active.

These exclusive %PRODUCTNAME VBA objects properties and methods are enabled when: • A Basic module is set with VBAModule special attribute. • Option VBASupport 1 compiler statement is placed before the first macro of the VBA Basic module. A few VBA objects are supported for Excel, Powerpoint and Word application files. Limited properties and methods are available for VBA objects.

VBA Model;Err object

Common objects

MSOffice Excel --------------------------------------------------------------------------------------

Excel Objects, Properties and Methods

Excel supported VBA objects Application
Columns
Range
Rows
Workbook
Worksheet

VBA Excel Model;Application

Application

Properties ActiveCell : Range ActiveSheet : Worksheet ActiveWorkbook : Workbook DefaultFilePath : String DisplayAlerts : Boolean LibraryPath : String Name : String PathSeparator : String - see GetPathSeparator function Methods Quit

Columns

Properties Address : String Methods Item(ndx : Variant) : Column

VBA Excel Model;Range

Range

Properties Methods ExportAsFixedFormat(Optional Type : Integer = xlTypePDF, Optional FileName : String, Optional Quality : Integer = xlQualityStandard, Optional IncludeDocProperties : Boolean, Optional IgnorePrintAreas = Boolean, Optional OpenAfterPublish : Boolean)

VBA Excel Model;Rows

Rows

Properties Methods

VBA Excel Model;Workbook

Workbook

Properties Methods

VBA Excel Model;Worksheet

Worksheet

Properties Methods

MSOffice Powerpoint --------------------------------------------------------------------------------- VBA Powerpoint Model;Application

PowerPoint Objects, Properties and Methods

MSOffice Word --------------------------------------------------------------------------------------- VBA Word;Application

Word Objects, Properties and Methods

VBA support in %PRODUCTNAME VBA Properties