BO XI 3.1 LiveOffice VBA macro to refresh all query

[Former Member]

hi,

we have migrated from BO 6.5 to BO XI 3.1.

some Business queries have to be manually converted to LiveOffice.

we still have a issue have we had in 6.5 a button to refresh all queries which a vba function

the code was the following:

Public Sub RefreshBO()

Application.Run ("BQ_Load")

Application.Run ("BQ_RefreshAll")

End Sub

does anybody knows how to do it in BO XI 3.1 ?

thank you for your help.

Pascal

Note :Plateform BO XI 3.1 Windows, BO Enterprise

[dzmitrydrazdou]

You can refresh all objects by executing the appropriate LiveOffice menu item:

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

I.e. CommandBars(1)=application menu; Controls("&LiveOffice")=LiveOffice submenu; Controls(6)=6th item in menu ("Refresh All Objects")

[Former Member]

Hi,

I have the same problem,

Can you explain it a little bit more?

Thank you

Qami