VBA functions in Slice

Slice supports the following TM1 VBA functions:

1. TM1RECALC1 – Recalc active worksheet

2. TM1REFRESH – Rebuild active worksheet

3. TM1REBUILDALL – Rebuild all worksheet in a workbook

4. DBSSEND – Send DBS in active worksheet

5. DBSSENDALL – Send DBS in active workbook

6. N_CONNECT – Connects to a TM1 instance

7. RunTIProcess(serverName,parameterValues…) – Execute TI processes from VBA or worksheets

The functions can be executed in VBA using Application.Run:

Sub RecalcWorkbook() 
Application.Run "TM1RECALC1" 
End Sub