VBA Analysis for Office - Repeat Member and Undo

[Former Member]

Hi,

we are working with Analysis for Office v1.4.

We are writing a complex macro and we need to set in vba the repeat members parameters and undo functionality, as shown in the image below.

Anyone has experience on that and know the method or formula to use?

Regards,

Veronica

[Former Member]

Hi Tammy,

yes, the Upgrade is scheduled soon. Anyway the question remains also for Analysis for Office 2.3.

Do you have any idea?

Regards,

Veronica

[TammyPowlas]

Veronica,

Analysis Office 1.4 is out of maintenance - please see SAP's Alex Peter's blog https://blogs.sap.com/2016/02/11/upgrade-your-analysis-office-14-release-soon/

Please upgrade to 2.3, latest SP, and then see if you can accomplish your task.

Tammy