How to return a two-dimensional C # array in VBScript

Question

I plan to develop a function in C # that will return a two-dimensional array. This new C # function will be called through a VB script. Also the length of the returned array will be dynamically changed, so I'm not sure how to return this array in vbscript.

Any information about the approach / pseudo-code will be very helpful. Thank you

Answer 1

I would recommend looking at a specialized solution for C # and VBA, for example ManagedXLL , ExcelDNA , etc., if you are going to do more of this in the future.

This will help you easily create XLL in a process that can be called directly from Excel / VBA.

-, 2003 Web Services Toolkit .