Automation Error while using method written in c# class library in Excel VBA
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.