BusinessObjects Board

development of a tool to extract universe information

hi folks,

i was working on a tool to extract details of a universe into a excel sheet.

I already have that tool in form of excel but the problem is that tool is compatible with only excel 2003 not with 2007 .
i was wondering if i could make some .exe file or someother file which does’nt have compatibility issues.

i hope this will help other members as well.
i am using BO 6.5

any advice how to proceed ?


nik96159 :india: (BOB member since 2008-11-18)

You can extract a lot of things using VBA embelded in BusinessObjectq full client reports or query the BO 6.5 repository. have you checked the Download or SDK section of BOB , they are planty of such code to achieve it. You can also try to adapt the VBA code of the excel sheet you are talking about and make VBA based dp in full client.


bernard timbal :fr: (BOB member since 2003-05-26)

tried to run tool mentioned in below link on my system
https://bobj-board.org/t/21029/6
but got this error
Runtime error ‘430’ class does not support Automation or does not support expected interface

the error is shown in this line of the code mentioned above in post
Quote:
Set DesignerApp = New Designer.Application

this may bcoz i have excel 2007 installed on my system

I am working on BO 6.5


nik96159 :india: (BOB member since 2008-11-18)

any inputs on this as i m still getting same error on my system


nik96159 :india: (BOB member since 2008-11-18)