OLEDBConnection.UseLocalConnection Property

Version Information
Version Added: Excel

Syntax

expression.UseLocalConnection

expression A variable that represents an OLEDBConnection object.

Remarks

This example sets the connection string of the first PivotTable cache to reference an offline cube file.

Example

With ActiveWorkbook.PivotCaches(1) .LocalConnection = _ "OLEDB;Provider=MSOLAP;Data Source=C:\Data\DataCube.cub" .UseLocalConnection = True End With 

See also:

• OLEDBConnection Object
• OLEDBConnection Object Members