TM1 Forum

to avoid some problems with the tm1 ribbon while running vba-code you can deactivate the ribbon.

Sub TM1_Ribbon_laden ()
ChDir "C:\Program Files (x86)\ibm\cognos\tm1\bin"
Workbooks.Open Filename:="C:\Program Files (x86)\ibm\cognos\tm1\bin\tm1pRibbonX.xlam"
Application.Run "RibbonClickTab"
End Sub


TM1 Ribbon entladen

Sub TM1_Ribbon_entladen()
Workbooks("tm1pribbonx.xlam").Close
End Sub

Gruss Robert
Danke.

And without losing the ribbon functions too!
eg: Run "DoGetAppFolderBlob", Run "DoGetAppFolder"