Macro in SAP BEx

[Former Member]

Can some one send me documents to create macro using VB script. As my client want some simulation report to know the total cost if he changes the individual cost fields.

I tried with the macro recording. But the layout of the report wont be same na.. and the total results also should reflect. the cost is with respect to the cost of raw materials used for the product creation. So the raw materials using also vary.. Can some one send me some document or sample code similar to the above situation please....

My email id is mchemparathy@gmail.com..

[Former Member · Accepted solution]

My advice would be to buy a good VBA book, then go to the following SAP Help library page:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a55f9e09411d2acb90000e829fbfe/content.htm">Integration with Visual Basic for Applications</a>

BTW, the link above is for BW 3.5 but the information is pretty generic. If you are using a different version of BI/BW, you may want to check out the help text for that version instead.

Hope this helps...

Bob