CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. August 14th, 2009, 10:52 AM #1
    Jim Bassett
    Jim Bassett is offline Member +
    Join Date
    May 1999
    Location
    Fort Worth Texas
    Posts
    614

    Question Accessing manage code from VBA

    Anyone know the technique for calling VB.NET methods (C# methods as well) from VBA code?
    Reply With Quote Reply With Quote
  2. August 14th, 2009, 01:30 PM #2
    Shuja Ali's Avatar
    Shuja Ali
    Shuja Ali is offline Elite Member Power Poster
    Join Date
    Jun 2004
    Location
    Kashmir, India
    Posts
    6,808

    Re: Accessing manage code from VBA

    Although I haven't tried that, but I believe it would be same as calling .NET code from VB6. You will have to build an interoperable DLL and register it in GAC. And then add a reference to it in the VBA code. IF you do a search here, you will number of examples on COM Interop.
    Reply With Quote Reply With Quote
  3. August 15th, 2009, 02:25 AM #3
    HanneSThEGreaT's Avatar
    HanneSThEGreaT
    HanneSThEGreaT is offline Elite Member Power Poster
    Join Date
    Jul 2001
    Location
    Sunny South Africa
    Posts
    11,284

    Re: Accessing manage code from VBA

    Here is a nice example from MSDN :

    http://support.microsoft.com/kb/317535
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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

Featured