C++ and Excel VBA Arrays Dll

[newbieme]

Hello Titans Of Programming !

What is the best way to pass a multidimensional array between Excel VBA and C++. I have been reading multiple SafeArray articles but I am not able to find a good solution.

Any simple example and/or tips would be much appreciated !!

Thanks in Advance :)

[newbieme]

Seriously..no one?

[coder777]

From googling, this is the best you may get:

http://www.vbforums.com/showthread.php?495753-Passing-2D-Array-from-VBA-to-C

[newbieme]

Thanks this solution seems to work great ! Though don't understand what safearrays are meant for :/

[coder777]

This has to do with the visual basic memory management and other things. See this:

http://forums.codeguru.com/showthread.php?360894-vb-and-safearray