WorksheetDataConnection Members (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Used to import data into the Data Model from data on the worksheet such as ranges and tables.

Name

Description

Application

Returns an Application object that represents the Microsoft Excel application. Read-only.

CommandText

Returns or sets the command string for the specified data source. Variant Read/Write

CommandType

Returns or sets one of the XlCmdType Enumeration (Excel) constants. For a WorksheetDataConnection object, this type will be set to xlCmdExcel.

Connection

Returns the internal connection string to the object in Excel. Variant Read-only

Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.

Parent

Returns an Object that represents the parent object of the specified WorksheetDataConnection Object (Excel) object. Read-only.

Show: