How to Reference a .Net Assembly from within VBA?

[TCook]

Hey All,

I want to create an assembly in .Net that I can reference and use in VBA.

I have a sample assembly that I've strongly named and that is loaded in the
GAC. However, I can not see from within VBA.

Please advise?

Thanks & Regards,

TC

 

[Scott M.]

You don't reference .NET assemblies from COM applications. You'll need to
register you .NET assembly for COM InterOp and then re-build it. This will
create a COM Callable Wrapper assembly that you would then reference from
your VBA project as normal.

 

[Herfried K. Wagner [MVP]]

I want to create an assembly in .Net that I can reference and use in VBA.

I have a sample assembly that I've strongly named and that is loaded in
the
GAC. However, I can not see from within VBA.

You can implement the functionality in a .NET class library and expose the
functionality for COM interop:

..NET Framework Developer's Guide -- Exposing .NET Framework Components to
COM
<URL:http://msdn.microsoft.com/library/en-us/cpguide/html/cpconexposingnetframeworkcomponentstocom.asp>

Visual Basic Language Concepts -- COM Interop
<URL:http://msdn.microsoft.com/library/en-us/vbcn7/html/vaconCOMInteroperability.asp>

 

[TCook]

Hey Guys,

Thanks for the advice. I figured out my problem. Although I had the class
tagged as a COM class and also had the assembly strongly named, I hadn't
signed the project or registered it for COM interop from within the
project's settings.

Once I signed and registered the assembly and rebuilt it, I was able to use
it from within VBA.

Thanks for the advice.

Best,

TC