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

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!

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


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Ellis" <[email protected]> wrote in message
news:[email protected]...
> 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!
>
>