Run this code on a machine that has Microsoft Excel installed: — create Excel sheet through OLE x = createOLEObject “Excel.Sheet” Sheet = x.ActiveSh…

Thanks man, but again this errors: — Runtime error: Attempt to place unsupported value type into OLE SAFEARRAY: dotNetObject:System.Double I think …

Thanks once more Mike! Yes. VB can call PutFullMatrix just fine. The example from works right out of the box. biddle: Once you know the pro…

Any more ideas? I really would like to use OLE/COM, but so far I have not been able to pass on any array data through OLE. Am I looking at a limitat…

Thanks Mike! Unfortunately, our code also gives me an error. Here’s the output: SafeArrayWrapper #(#(4.59825, 4.48692, 5.19677, 5.80181, 2.25653), #…

Nice! How’d you go about if you want to guarantee a minimum distance between all the random positions? So, say you have that irregularly tesselated pl…

Small update to this problem: Larry Minton from Autodesk pointed out to me that the problem in this case is that the struct does not declare a constr…

Jeeeeeez. I assume talks about what you just said? I would NEVER have found that solution… Thank you very much indeed, again! – MartinB

=8-) Wow! What on earth made you try that?! Is there any logic in that I can create an array of the struct, but not the struct itself? Another dotNet…

OK, thanks anyway! – MartinB

Yes, that seems to be the problem. I can create a dotNetClass value for the struct using dnc = dotNetClass “alglib.lbfgs+lbfgsstate” but I don’t now…

OK, Mike, you’re now the official hero of the day!! After removing a stupid mistake in my script this works just beautifully. And it is a great showc…