VBA Rebuild Current Book

[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

[Paul Segal]

Try Application.Run "TM1REFRESH" rather than "TM1RECALC". Also, the search box above is your friend.

[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.

[gtonkin]

Try

Code: Select all

application.run "TM1RebuildCurrentBook"

[initm1]

this works thank you.