Manipulating TM1 9.5 Sandboxes in Excel VBA

[oudoyen]

Is it possible (either through undocumented API calls or TM1 macro functions) to change which sandbox an excel worksheet reads/writes to?

I am creating a data_input_template in Excel 2007, and I would like to globally change/set the sandbox the users will write to when they open the workbook (in the Workbook_Open() event).
The users will be able to commit their changes to the [base] sandbox whenever they want. Also if there are any uncommitted data in the current sandbox when the workbook is closed, the users will be asked if they want to commit those changes to the [base] sandbox (in the Workbook_BeforeClose() event).

[asingla83]

Anyone has any good suggestion on this?

[homebunny]

i'm also searching for this functionality, has anyone found a solution?

[nick_leeson]

This is a good place to start for setting the Sandbox using VBA.

http://www.tm1forum.com/viewtopic.php?f ... 33&start=0

Hope this helps

Cheers