VBA code to Refresh Connection for Excel Add-in for Analysis Servi

[Guest]

Anybody know the vba code to Refresh Connection in cube analysis? or any
other automation option?

For some reason, when using Refresh Sheet returns #VALUE! but Refresh
Connection works well.

Thanks!

 

[Rob van Gelder]

Having never used Analysis Server, I can't say how it works...
My understanding is that it's a standard QueryTable.

Sub test()
Dim qtb As QueryTable

For Each qtb In ActiveSheet.QueryTables
qtb.Refresh
Next
End Sub