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

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.


Show quoteHide quote

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>

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


Show quoteHide quote

Adding Lines to Access Database
Merging two VB.NET projects
Detecting textchanged event when user initiates it
Asynchronous Socket Server Question
how to put two textboxes under each other?
where should the client app write the xml file to?
Creating a new database with limits using SMO
the find in a dataview???
Communicate with parallel port via web interphace
Starting field on a form