Reference Properties

Name

Returns

Description

BuiltIn

Boolean

Read-only. Returns if the reference is built-in or added by the developer. The Visual Basic for Applications and Microsoft Excel 12.0 Object Library references are built-in and cannot be removed.

Description

String

Read-only. Returns the description of the reference, which is the text shown in the Object Browser.

FullPath

String

Read-only. Returns the path to the workbook, DLL, OCX, TLB, or OLB file that is the source of the reference.

Guid

String

Read-only. Returns the globally unique identifier for the reference.

IsBroken

Boolean

Read-only. Returns True if the reference is broken (is not available on the machine).

Major

Long

Read-only. Returns the major version number of the referenced file.

Minor

Long

Read-only. Returns the minor version number of the referenced file.

Name

String

Read-only. Returns a short name for the reference (for example, VBA or Excel).

Type

vbext_ RefKind

Read-only. Returns the reference type, vbext_rk_TypeLib for DLLs and so on, or vbext_rk_Project for other VBProjects.

0 0

Post a comment