Re: Use COM object from Excel VBA - made in .NET "ActiveX component can't create object"

[DotNetJunkies User]

I am having same problem. I have C# dll which I compiled with COM Interop option and created type library .tlb file.
This works fine on my machine but doesn't work when moved to another machine.

I think Type library .tlb file has to be registered on another PC as it is COM interop. It works on my pc because when I compile it gets registered on my PC.

You need to use regasm.exe to register .tlb file using /tlb option.
for more information on registering type library refer to the below link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cptools/html/cpgrfAssemblyRegistrationToolRegasmexe.asp

---
Posted using Wimdows.net NntpNews Component -

Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

[DotNetJunkies User]

Ok, There is a big difference in the .NET dll and traditional windows dll. Actually even traditional windows dlls are not all same. Some conform to COM model to various degree, some are just plain libraries. .NET dll just contains the info good enough for the .NET class loader to take on. You cannot use it in traditional sense.

COMInterop. Making things work backwords is a big trouble. MS has lot of support for using old dll's in .NET but reverse is extremely painful. I suggest you recreate your application in older version of VStudio. .NET is great but only if you are willing to migrate everything to .NET