Manipulating TM1 9.5 Sandboxes in Excel VBA
Posted: Thu Jan 28, 2010 8:12 pm
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).
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).