Macros for refreshing Live Office objects

I have to use Business Objects reports saved in excel format as Input and then run macros on these to perform calculations/validations and then email the results. So far I have been creating the macros by using manually saved Business Objects reports.

Now I want to automate the generation of the Business objects reports and as soon as that is complete execute my validation macros on these reports.

I came across the Business Objects Live Office Add-In which allowed me to link the excel report headers to the Business object report. I can manually click on the headers in any report and from Menu option select Live Office-->Refresh Objects option to refresh my report.

Is there any way that for automating the above operation of refreshing the Live office objects?

TIA

This will run the refresh command from the menu bar :
Application.CommandBars(1).Controls("&LiveOffice").Controls(4).Execute

Dear Florentbr,

Could you please give step-by-step instructions to achieve Live Office trigger in excel 2010.

Much appreciated..

Thanks