Run Business Objects Report from Excel using VBA

[ferret]

Hi All,

Assuming this can be done does anybody have a code snippet to point me
in the right direction?

Regards

Michael Beckinsale

 

[Guest]

Hi Michael

To point you in the right direction will require a little more information.

 

[ferret]

Hi Steve,

Thanks for replying, l was beginning to think l was the only person
who wanted to do something like this!

I am pretty comfortable with Excel & VBA programming to link to
external databases etc but have never had to do so with BO.

Basically the problem is this:

I want to build an Excel workbook which will effectively be a
'template' run on a monthly basis that will run 3 existing Business
Objects reports and import the information returned into the Excel
workbook for further data analysis. I can forsee that l will probably
have to handle the 'login' in some way and the parameters required to
run the report. The 'template' needs to be as fully automated as
possible so the macro will be triggered by a button / menu item or
whatever.

Hope this helps, any help & guidance you can give will be gratefully
appreciated, there doesn't seem to be much help out their for vba
programming BO. Do you know any good sites?

Regards

Michael beckinsale

 

[Guest]

Hi Steve,

Thanks for replying, l was beginning to think l was the only person
who wanted to do something like this!

I am pretty comfortable with Excel & VBA programming to link to
external databases etc but have never had to do so with BO.

Basically the problem is this:

I want to build an Excel workbook which will effectively be a
'template' run on a monthly basis that will run 3 existing Business
Objects reports and import the information returned into the Excel
workbook for further data analysis. I can forsee that l will probably
have to handle the 'login' in some way and the parameters required to
run the report. The 'template' needs to be as fully automated as
possible so the macro will be triggered by a button / menu item or
whatever.

Hope this helps, any help & guidance you can give will be gratefully
appreciated, there doesn't seem to be much help out their for vba
programming BO. Do you know any good sites?

Regards

Michael beckinsale

Hi Michael,
I've touched on this subject very briefly myself, and only recently, but as
you say, there's precious little in the way of documentation. My approach
has been to load up the busobj library (which as I recall is buried somewhere
in the BO installation dir) and play with the object model in say Access or
whatever your preferred VBA environment is.
There's also a section in the appendix of
'BusinessObjects_access_analysis.pdf' which comes with the install as well,
but it's not very useful. So far I've managed to start BO remotely from
Access (using the Shell command) and load up some reports, but that's about
it.

Good Luck

Rufus

 

[michael.beckinsale]

Hi Rufus,

I have taken a lok at the documentation you mentioned and as you say
its not very helpful!

Would you mind sending me the code you have beens uceesful with so
far? At least it will point me in the right direction.

I have loaded the object model into Excel VBA but because of the way
Bo has been distributed on site l cannot access the associated help
files. Talk about obstacles being put in the way.

Anyway thanks for your help so far.

Regards

 

[Guest]

Hi All,

I'm very interested in this code.. Did anyone had any luck with this?

Regards,
Hendrik