Where is the VBA button in BI 4 ? (like in Excel)

[Former Member]

I just started to use BI 4, before that i used BO XIR2 and i had a VBA button.

I can't find it in BI 4, is there one ?

[CdnConnection]

Kuldeep,

VBA is NOT supported anymore within BI4. You will need to start using RESTful as your SDK choice. If you have any question about SDK using RESTful, post you question within the community. Currently many of the older links are still NOT working.

http://go.sap.com/community/topic/business-one-sdk.html

Link to getting started with RESTful for BI4x

http://sapassets.edgesuite.net/sapcom/docs/2015/07/8e203eaf-557c-0010-82c7-eda71af511fa.pdf

https://wiki.scn.sap.com/wiki/display/BOBJ/SAP+Business+Intelligence+Platform+RESTful+Web+Services+f...

Regards,

Ajay

[former_member198519]

Thanks Ajay :). Even I thought the same, but seeing Mani's blog I thought some of VBA scripts can work. Though the limitation is there.

[former_member198519]

Deski used to provide the VBA script option. But now Deski is a legacy tool now. Still there is a way to use VBA script in business objects (obviously not the way we used too, but worth looking into)

https://blogs.sap.com/2013/04/30/business-objects-program-object-what-we-can-do/

[Joe_Peters]

I'm assuming you're looking for the VBA editor in Desktop Intelligence? If so, DeskI does not exist in BI4; it was replaced entirely with Web Intelligence, which does not support VBA.

[TammyPowlas]

Please see Stephane's blog here re VBA and BI4: https://blogs.sap.com/2016/10/03/bi4-restful-sdk-excel-is-back/