TM1 DBSW loop in VBA

[DBSENABLE]

New to TM1. Attempting to replace DBSW formulas with VBA loop to send values back to TM1. However, VBA loop is much slower than TM1 formulas, likely because the VBA cannot batch the DBSW.

For x = 1 to 250000
var_value = Run("DBSW", var_input(x), ...)
Next x

What options are there to batch the DBSW?
Can W_DBSENABLE be applied?
Examples are appreciated.

[Steve Rowe]

Pretty sure you can't do this via VBA.

If you have the skills to write VBA then you are likely better off putting the data into a csv (programmatically) and then triggering a TI to load the data (programmatically).