user1987691
user1987691

Reputation: 11

OLAP cube connection displayed in Excel

I am creating a pivot table in Excel 2010 using a connection to an OLAP cube.

I am trying to figure out how to have the path and file name of the cube and the last refreshed date/time to be displayed and printed into the Excel sheet.

Basically, the same information that is displayed in the Workbook Connections (under the data tab) to be printed within the sheet where the pivot table is located.

Is there a way to do this?

Thanks!

Upvotes: 1

Views: 1691

Answers (1)

QArea
QArea

Reputation: 4981

This will print all of the connection names to the debug window.

Dim conn As WorkbookConnection
For Each conn In ActiveWorkbook.Connections
   Debug.Print conn.Name
Next conn

Similarly, you can display information on the sheet.

Upvotes: 2

Related Questions