• Please make sure the page has finished loading before you browse the FAQ list.


How can I edit matrix values over COM using Excel/VBA?

Following variants are possible:
- By referencing the matrix value by zone numbers:
Visum.Net.ODPairs.ItemByKey(100, 200).AttValue('MatValue(1)') = 1000

- By referencing the matrix value by row and column.
Visum.Net.Matrices.ItemByKey(1).SetValue 1, 2, 5000

- More efficient is using a safearray as input:
Visum.Net.Matrices.ItemByKey(1).SetValues myArray

Example codes are available in: