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

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

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