VBA supported Data Model

LibreOffice Basic adds this set of functionalities when VBA Office support is active.

These exclusive LibreOffice 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.

Common objects

Objetos, propiedades y métodos de Excel

Objetos de VBA admitidos por Excel
Application Columns	Range Rows	Workbook Worksheet

Aplicación

Propiedades

• ActiveCell : Range

• ActiveSheet : Worksheet

• ActiveWorkbook : Workbook

• DefaultFilePath : String

• DisplayAlerts : Boolean

• LibraryPath : String

• Name : String

• PathSeparator : String - see GetPathSeparator function

Métodos

• Quit

Columnas

Propiedades

• Address : String

Métodos

• Item(ndx : Variant) : Column

Range

Propiedades

Métodos

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

Rows

Propiedades

Métodos

Workbook

Propiedades

Métodos

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

Worksheet

Propiedades

Métodos

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

Objetos, propiedades y métodos de PowerPoint

Objetos, propiedades y métodos de Word