DataFeedConnection Members (Excel)

GitHub-Mark-64px

Contribute to this content

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

Contains the data and functionality needed to connect to data feeds. The same object is used for all Data Feed types.

Name

Description

CancelRefresh

Cancels a refresh operation on a data feed connection.

Refresh

Refreshes the data feed connection.

SaveAsODC

Saves the data feed connection as a Microsoft Office Data Connection file.

Name

Description

AlwaysUseConnectionFile

True if the connection file is always used to establish connection to the data source. Boolean. Read/Write

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 the command string for the specified data source. Variant Read/Write

Connection

Returns or sets a string that contains Service Contract settings that enable Microsoft Excel to connect to a Data Feed data source. Variant Read/Write

Creator

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

EnableRefresh

True if the connection can be refreshed by the user. The default value is True. Boolean Read/Write

Parent

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

RefreshDate

Returns the date on which the OLE DB connection was last refreshed. Date. Read-only

Refreshing

True if an OLE DB query is in progress for the specified data source connection. Boolean Read/Write

RefreshOnFileOpen

True if the connection is automatically updated each time the workbook is opened. The default value is False.

RefreshPeriod

Returns or sets the number of minutes between refreshes. Long Read/Write

SavePassword

True if password information in a data feed connection string is saved in the connection string. False if the password is removed.

ServerCredentialsMethod

Returns or sets the type of credentials that should be used for server authentication. XlCredentialsMethod Enumeration (Excel) Read/Write

SourceConnectionFile

Returns or sets a String indicating the Microsoft Office Data Connection file or similar file that was used to create the connection. Read/Write

SourceDataFile

A path to the original file used to create the connection. In the case of an OData connection, this is the location of the *.atom or *.atomsvc file used to create the connection. String Read/Write

Show: