|
-
Apr 7th, 2009, 08:28 PM
#1
Thread Starter
PowerPoster
VS 2008 pass vba udt to vb.net dll
I can make a vb.net dll with a com interface and it works fine when using it from VBA (Excel). I need to pass a udt into this .net dll and I am not having luck. Ive tried passing it as an object and Ive tried defining a structure exactly like the VBA UDT and passing it that way and it still doesnt work. The error I get complaines about an unsupported interface.
Does anyone have any suggestions. If anyone knows of a small example anywhere Id appreciate being pointed to it. Ive done quite a bit of searching and cannot find anything.
I tested the dll without any udts (just passing a string) and it worked fine, so Im sure Ive got it all setup right except for the UDT passing part.
I dont need help on the VBA side ... I just need to know how to set up my vb.net dll to accept UDTs.
Thanks in advance for any help.
Last edited by Muddy; Apr 7th, 2009 at 08:43 PM.
Reason: clarity
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|