Wbk.DC

The wbk.DC object has properties and methods related to the Data Connector attached to the active Workbook.

Properties

Property Access Description
wbk.DC.OCFiles$ Read Only Returns the relative path of the connector cpp file to the Apps root folder. To construct the full OC file path, use

"%@A"+wbk.dc.OCFile$

wbk.DC.type$ Read Only Returns the connector type, CSV_Connector or JSON_Connector.

Methods

Method Description
wbk.DC.remove(nn) Remove data connector.

nn = 0: Default value when nn is not specified. Remove data connector object from the current workbook, and remove edit protection from all destination sheets in this workbook.
nn = 1: Disconnect data source from the current worksheet and remove its edit protection.
nn = 2: Remove only eidt protection from the current worksheet, but connection will be kept.

wbk.DC.import(nn) Reimport the current data source into active worksheet.

nn = 1: Reimport by opening the Selection dialog first
nn = 0: Default value when nn is not specified. Reimport directly.

Examples

See Also