TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Swapnil Palande
NA
15
0
Automation Error while using method written in c# class library in Excel VBA
Jul 20 2009 10:35 AM
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.
Reply
Answers (
0
)
shortcut icon for customise file extension (help needed)
Transfer data to Crystal Report