BusinessObjects Board

How to get list of reports which contains macros?

sdk development
#1

Hi All,

I need to prepare a list of reports which contains Macros. The reports are in BO 5x versions and XI-R2 versions. Is it possible to get the reports that contains macros in it, through the Business Objects SDK?

Regards,
Bhuvan R

Bhuvan (BOB member since 2008-12-02)

#2

Should be possible. This utility … List objects used in a series of reports … can cycle through a series of full client reports. You could tweak it to look for VBA code, rather than data provider objects. To “look for” VBA code, do a google search for VBA Extensibility. Basically, it’s a built-in Microsoft library (not BusObj) that allows VBA to write VBA.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#3

Thanks all. I got my requirement done. Using the Desktop Intelligence SDK, I got this info. objBoapp.activedocument.Macros has the macro information for the reports.

Thanks for your support.

Bhuvan (BOB member since 2008-12-02)