Refresh CRM data in Excel 2007 using VBA

[Marc]

Hi,

I want to refresh my CRM data in Excel 2007 using a VBA macro. The macro
recorder doesn't leave any trace.

In the older versions i used the following macro to trigger a menu item but
don't know how to do it in the new office 2007 layout:

Dim oBar As CommandBar
Dim oCtrl As CommandBarControl

Application.CutCopyMode = False
Set oBar = Application.CommandBars("Worksheet Menu Bar")
Set oCtrl = oBar.Controls("Hyperion").Controls(6).Controls(1)
oCtrl.Execute

Anyone a clue?