Connections Members (Excel)

GitHub-Mark-64px

Contribute to this content

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

A collection of Connection objects for the specified workbook.

Name

Description

Add2

AddFromFile

Adds a connection from the specified file.

Item

This method creates a connection item.

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.

Count

Returns the number of objects in the collection. Read-only Long.

Creator

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

Parent

Returns the parent object for the specified object. Read-only.

Show: