Results 1 to 5 of 5

Thread: VS 2008 pass vba udt to vb.net dll

Threaded View

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Feb 2001
    Location
    Crossroads
    Posts
    3,046

    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
  •  



Click Here to Expand Forum to Full Width