Skip to Content
0
Apr 23, 2014 at 02:24 PM

Expand to level for a structure in VBA

878 Views

We use collapsed structures in our query for performance reasons, so we do not show all key figures when the workbook opens. Now we would like to have a functionality written in VBA which should open the structure up to a specified level like it is done when I use "Expand to level" -> "1" in the context menu. (This is of course only a part of the functionality)

I already tried to use SAPSetFilter without any success. Is there any VBA command available that I could use?

Best regards,

Andre