<div>
Maybe one of these links will point you in the right direction:<br />
<br />
<a href="http://social.msdn.microsoft.com/Forums/vstudio/en-US/fc008bcc-986a-429e-9e1b-06fc1a7f2d5b/calling-net-dll-from-vba" rel="ugc nofollow">http://social.msdn.microsoft.com/Forums/vstudio/en-US/fc008bcc-986a-429e-9e1b-06fc1a7f2d5b/calling-net-dll-from-vba</a><br />
<br />
<a href="http://richnewman.wordpress.com/2007/04/15/a-beginner%E2%80%99s-guide-to-calling-a-net-library-from-excel/" rel="ugc">http://richnewman.wordpress.com/2007/04/15/a-beginner%E2%80%99s-guide-to-calling-a-net-library-from-excel/</a>
</div>


Maybe one of these links will point you in the right direction:

http://social.msdn.microsoft.com/Forums/vstudio/en-US/fc008bcc-986a-429e-9e1b-06fc1a7f2d5b/calling-net-dll-from-vba [http://social.msdn.microsoft.com/Forums/vstudio/en-US/fc008bcc-986a-429e-9e1b-06fc1a7f2d5b/calling-net-dll-from-vba]

http://richnewman.wordpress.com/2007/04/15/a-beginner%E2%80%99s-guide-to-calling-a-net-library-from-excel/ [http://richnewman.wordpress.com/2007/04/15/a-beginner%E2%80%99s-guide-to-calling-a-net-library-from-excel/]

<div>
For that to work the DLL has to be COM compliant. I have actually created a wrapper DLL just so, but have issues passing through arrays. I will be trying the methods suggested here<br />
<br />
<a href="http://stackoverflow.com/questions/70501/exposing-nested-arrays-to-com-from-net" rel="ugc">http://stackoverflow.com/questions/70501/exposing-nested-arrays-to-com-from-net</a><br />
<br />
any other suggestions are welcome.<br />
<br />
Leon
</div>


For that to work the DLL has to be COM compliant. I have actually created a wrapper DLL just so, but have issues passing through arrays. I will be trying the methods suggested here

http://stackoverflow.com/questions/70501/exposing-nested-arrays-to-com-from-net [http://stackoverflow.com/questions/70501/exposing-nested-arrays-to-com-from-net]

any other suggestions are welcome.

Leon

<div>
Provided solution to my own question
</div>


<div>
<div class="content wysiwyg-content">
Hi, our users would like to access a .NET none COM DLL with VBA. What is the best way for us to proceed? We do not have access to the DLL so it can not be recompiled.
</div>
</div>


Hi, our users would like to access a .NET none COM DLL with VBA. What is the best way for us to proceed? We do not have access to the DLL so it can not be recompiled.

Access a none COM dll with VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.