Automation Error while using method written in c# class library in Excel VBA

Question

Hi All,

I am facing problem in com interoperability.

I have create dll using C#.net. Now I want to use this dll in excel vba.

I have generate tlb file by following steps given below:
1.) Make assessembly COM visible
2.) Register for COM interop

In excel visual basic editor I gave reference to the tlb file.

In visual basic editor I am able to access method there in tlb file.

But when I run the code it gives "Automation error".

Please help me to solve this problem.

The programme don't give any error on system that have VS6.0 installed on it.

But when I run this programme that don't have VS6.0 installed it give me "Automation error"

Thanks and regards,

Swapnil.