Interop.VBA Problem with Collections from C# app

[Jim Dandy]

I have a VB 6 dll with the following method signature:

Public Sub ParseImageTags(ByRef InputLinksField As String _
, ByRef KeyWordCollection As Collection)

From a Visual Studio 2003 ASP.Net C# project I added a reference to
this DLL.

I have this line of code in the C# app where I'm creating a Collection
to pass by reference to the ParseImageTags method:

VBA.Collection c = new VBA.Collection();

When I run the app I get the following error on the above line of
code:

COM object with CLSID {A4C4671C-499F-101B-BB78-00AA00383CBB} is either
not valid or not registered.

I have a reference to Interop.VBA.

Any ideas what might be causing this error?

Thanks in advance for any help with this!

 

[Tamir Khason]

What class id is it. It may be class id of supporting class, but not
registered on machine

 

[raffman1976]

I'm having the same problem

I'm having the same problem as above. In a C# environment, the following code will compile and give me a run time error:

VBA.Collection coll = new VBA.Collection();

Error:

Retrieving the COM class factory for component with CLSID A4C4671C-499F-101B-BB78-00AA00383CBB failed due to the following error: 80040154

I need a vba collection to pass as a parameter to a COM server. Is there a way to create this in C#?