Page 1 of 1
VBA Rebuild Current Book
Posted: Thu Jul 21, 2016 10:25 am
by initm1
Hi, Please help me out here. I am using below VBA to Rebuild Current Book but doesnt seem to work.
I want to rebuild the whole workbook wherever I have activeform. Please advice
sub test1()
Application.Run "TM1RECALC"
end sub
Re: VBA Rebuild Current Book
Posted: Thu Jul 21, 2016 10:35 am
by Paul Segal
Try Application.Run "TM1REFRESH" rather than "TM1RECALC". Also, the search box above is your friend.
Re: VBA Rebuild Current Book
Posted: Thu Jul 21, 2016 11:09 am
by initm1
I tried this but still doesn't work. Not sure what I'm missing out. It works perfect if I use teh TM1 ribbon Rebuild current book.
Re: VBA Rebuild Current Book
Posted: Fri Jul 22, 2016 6:03 pm
by gtonkin
Try
Code: Select all
application.run "TM1RebuildCurrentBook"
Re: VBA Rebuild Current Book
Posted: Mon Jul 25, 2016 12:22 pm
by initm1
this works thank you.