Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

VBA: Display as Key


I have an workbook. The query is on sheet2 and the result area is on sheet1. The query contains a hierarchy. I would like change the hierarchy display from key to name or key and name. Olap-Functions for active cells works well. But with my VBA coding it doesn't work.


Private Sub Button21_Click()


Run "SAPBEX.XLA!SAPBEXfireCommand", "PC03", Selection

End Sub

Where is my problem?

Can someone help me with my coding.

Thank you


Former Member
Not what you were looking for? View more on this topic or Ask a question