Page 1 of 1
Rebuilding Active Forms using VBA
Posted: Fri Aug 10, 2012 5:11 am
by eddoria
I need to create a macro which selects a sheet and rebuilds the active form. Is this possible using VBA? We are using Excel 2003 and TM1 9.5.2
Any help with this would be greatly appreciated.
Thanks and regards
Vera Hawkins
Re: Rebuilding Active Forms using VBA
Posted: Fri Aug 10, 2012 5:26 am
by BigG
I think you are after
ActiveSheet.Select
Application.Run "TM1RECALC1"
but if you search the forum you may find some better examples
Re: Rebuilding Active Forms using VBA
Posted: Fri Aug 10, 2012 7:02 am
by lotsaram
BigG wrote:I think you are after
ActiveSheet.Select
Application.Run "TM1RECALC1"
but if you search the forum you may find some better examples
In fact you would be needing Application.Run "TM1REFRESH" which is the macro to rebuild an active form. TM1RECALC1 recalculates the sheet but it will not trigger rebuilding of the rows of an active form.