Skip to Content
0
Jul 27, 2016 at 03:01 PM

Cell Style - Using SAPSetFormat

211 Views

Hello,

I'd like to ask whether somebody has used command SAPSetFormat for changing a cell style.

My query displays cost elements in rows, and I would like to highlight an specific master data value, not a measure.

I have seen it could be done by design panel. But above, is just the first step, because I would like to perform a check of a previous master data value (wbs element attribute).

So, through AfO user guide I found out the command SAPSetFormat, but the example is not very clear (complete newbie with VBA).

And googling I found Alex's example, but the example, again, is not very clear for me.

"result = Application.Run("SAPSetFormat", , dataSource, StyleName, "VIRTUALDIMENSION", firstLine, "MEMBER", secondLine)"

I have tried different combinations, with no success.

If anybody has used it and could provide an example, it'd be much appreciated.

Regards,

Francis.