all groups > dotnet interop > october 2006 >
You're in the

dotnet interop

group:

How to Reference a .Net Assembly from within VBA?


How to Reference a .Net Assembly from within VBA? TCook
10/27/2006 12:59:27 AM
dotnet interop: 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

Re: How to Reference a .Net Assembly from within VBA? NickHK
10/31/2006 12:00:00 AM
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

[quoted text, click to view]

Re: How to Reference a .Net Assembly from within VBA? Cindy M.
10/31/2006 12:52:25 PM
Hi TCook,

[quoted text, click to view]
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 :-)
AddThis Social Bookmark Button