Excel VBA and Business Objects

[nickwilshaw]

Hi guys,

I appreciate there is precious little documentation on the web about using VBA to control Business Objects but wondered if anyone could give me a little insight into this:

I want (if possible) to be able to auto-run Refresh All Objects when the workbook opens.

I have tried using the code:

Application.CommandBars(1).Controls("&LiveOffice").Controls(6).Execute

to no avail as this just states invalid procedure error.

My next step would be to autopopulate the date fields so as to run at the previous month end.

BTW, I'm using Excel 2007

 

[Ria1]

We've recently upgraded to Excel 2010 and I have got the same issue now. How do I refresh my Live Office queries automatically using VBA.
The old solution doesnt work anymore:

Application.CommandBars(1).Controls("&LiveOffice").Controls(6).Execute

And I've not been able to find a solution that does work in Excel 2010.
Is there anyone who can help me with this?

Thanks in advance,
Ria