Muokkaa

Jaa

OLEDBConnection.LocalConnection property (Excel)

  • Artikkeli

Returns or sets the connection string to an offline cube file. Read/write String.

Syntax

expression.LocalConnection

expression A variable that represents an OLEDBConnection object.

Remarks

For a non-OLAP data source, the value of the LocalConnection property is an empty string, and the UseLocalConnection property is set to False.

Setting the LocalConnection property does not immediately initiate the connection to the data source. You must first use the Refresh method to make the connection and retrieve the data.

The value of the LocalConnection property is used if the UseLocalConnection property is set to True. If the UseLocalConnection property is set to False, the Connection property specifies the connection string for query tables based on sources other than local cube files.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.