Excel 2007 -- Object does not support automation

rchiu5hk · 10-08-2009, 11:14 PM

Dear all,

I am using Excel 2007.
I have written the c# dll which will use in Excel.
Dim myObject as Object
set myObject=new dllname.dllclass // it show the captioned error.

Do you know why?
I think it should be excel vba program of the lines above.

Please help!!!

**shg** · 10-08-2009, 11:39 PM

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.

rchiu5hk · 10-08-2009, 11:56 PM

I have solved by recreating the new c sharp project and rebuild ddl and tlb.
It solved .

**royUK** · 10-09-2009, 02:52 AM

Originally Posted by rchiu5hk

I have solved by recreating the new c sharp project and rebuild ddl and tlb.
It solved .

1. Do not ignore Moderator's requests
2. use Code tags when posting code in the forum
3. mark the thread Solved

I strongly suggest that you read the forum Rules that you agreed to when joining the Forum. You've managed to break three in one Thread. basically, read & follow the Rules or don't bother posting!