Reference to .NET 1

[RapidE]

Can sombody explain me why I can not add reference to the dll from excel VBA macro?

I have created a Dll using VB.NET and I want to add this dll as reference for VBA macro written in Excel and later possibly for other Office products.

Thanx

 

[chiph]

Did you tell VB.NET to create a COM-Callable Wrapper (CCW) for your class? The COM and .NET worlds can talk to each other, but you have to make sure you set the options correctly.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[hede]

I have the same problem, but how to I do it?

venlig hilsen/best regards
Anders Hedegaard

http://www.dataworks.dk/

 

[chiph]

Take a look at:

http://msdn.microsoft.com/library/d...n-us/cpguide/html/cpconcomcallablewrapper.asp

and

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/callcomcomp.asp

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[RapidE]

Thanks chiph, got a star.

I don't use Microsoft IDE. I use SharpDevelop it is FREE tool to develop .NET application under VB and C#. But I created COM callable *.tlb using CCW delivered with Microsoft .NET SDK package.

See SharpDeveloper homepage at

http://www.icsharpcode.com/OpenSource/SD/

 

[DrJavaJoe]

Take a look at this code from PCS.

http://www.planetsourcecode.com/vb/...6&lngWId=1&txtForceRefresh=725200511203545132

Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.

 

[SqueakinSweep]

Make sure you also turn Option Strict On, and resolve any casting errors, before using your DLL from other apps, as it will greatly help in error trapping.


Sweep