How to Reference a .Net Assembly from within VBA?
 

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 Excel.

Please advise?

Thanks & Regards,

TC

How to Reference a .Net Assembly from within VBA?
 

Excel is COM based, so AFAIK, you would need to make a COM wrapper for any
..Net component in order to access it from VBA.

NickHK

"TCook" wrote in message
...
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 Excel.

Please advise?

Thanks & Regards,

TC

How to Reference a .Net Assembly from within VBA?
 

Hi TCook,

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 Excel.

You might find Andrew Whitechapel's .NET Development for Microsoft Office a
useful reference work. He describes how to create a COM wrapper for managed
code DLLs and how to call them from VBA code.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)