VBA code for Essbase ZoomIN

[adamexcel1982HU]

Hello,

I would like to use macro (VBA) for ZoomIn Essbase

[table="width: 500"]
[tr]
[td][/td]
[td]A[/td]
[td]B[/td]
[td]C[/td]
[td]D[/td]
[td]E[/td]
[td]F[/td]

[/tr]
[tr]
[td]1[/td]
[td][/td]
[td][/td]
[td]Country[/td]
[td]Country[/td]
[td]Country[/td]
[td]Country[/td]

[/tr]
[tr]
[td]2[/td]
[td][/td]
[td][/td]
[td]Y2015[/td]
[td]Y2015[/td]
[td]Y2015[/td]
[td]Y2015[/td]

[/tr]
[tr]
[td]3[/td]
[td][/td]
[td][/td]
[td]Jan[/td]
[td]Feb[/td]
[td]Mar[/td]
[td]Apr[/td]

[/tr]
[tr]
[td]4[/td]
[td][/td]
[td][/td]
[td]volume[/td]
[td]volume[/td]
[td]volume[/td]
[td]volume[/td]

[/tr]
[tr]
[td]5[/td]
[td]products[/td]
[td]origin[/td]
[td][/td]
[td][/td]
[td][/td]
[td][/td]

[/tr]
[/table]


I would like to ZoomIn to "Products" and "Origin" as well to the bottom level. File name eg.: Planning.xlsm Worksheet name: Essbase


Later on I wuold also make a flash back with VBA if it is possible.

Thanks for helping out.