Skip to Content

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

VBA: Display as Key

Hi

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.

Code

Private Sub Button21_Click()

Range("B12").Activate

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

End Sub

Where is my problem?

Can someone help me with my coding.

Thank you

Markus

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