Retrieving Query from Webi Using Excel Macro

system · July 24, 2009, 11:47am

Hi Gurus,

I need to list out the queries of all the WEBI reports from our derver in an excel file using VBA and SDK. I have done a extensive search in BOBOJ but couldn’t fine any.

I do not have option to use Java / .Net sdk. The only option is to use VBA in Excel with BO SDK. Please suggest if this possible and doable. if so please guide me to start with.

Thanks
tkj

BOBJ_USER (BOB member since 2004-10-26)

system · July 27, 2009, 12:29pm

From my experience, I do not think that is possible using VBA SDK.

nithya_raj (BOB member since 2007-02-03)

system · July 27, 2009, 2:59pm

hi, it is not with VBA SDK.

am asking if it is possible using BO SDK in Excel.

BOBJ_USER (BOB member since 2004-10-26)

system · July 27, 2009, 3:27pm

That is VBA.

Dave Rathbun (BOB member since 2002-06-06)

system · July 27, 2009, 4:08pm

yea That is VBA not VBA SDK that is what i want to clarify nithya_raj.

BOBJ_USER (BOB member since 2004-10-26)

system · July 28, 2009, 4:37am

From my experience, I do not think it is possible with BO SDK in Excel!

nithya_raj (BOB member since 2007-02-03)