Automation Error

[AsimZia]

Hi there,
I have developed a .NET Assembly using VB.NET, which only have a msgbox to
display. then what i have done is i have a and VB6.0 Addin working absolutely
fine with COM Applications. I have registered my .NET Assembly with strong
name and and successfully installed in GAC. Its working fine on my machine
but when i try to deploy it on test machine it started giving me "Runtime
Error: Automation Error".
On the deployment machine i have .NET Framework2.0 installed and registered
my VB6.0 Addin with regsvr32 command and register .NET assembly using RegAsm.
The strange thing is i have installed VB6.0 on deployment machine as well
and while running from the IDE it is working fine with Excel i mean the
ADDIN, but as soon as i try to run the Addin without having VB6.0 running it
started the samething again.

Please suggest me something, i have tried nearly everything avaliable on
internet.

 

[XL-Dennis]

Hi,

Sorry to hear that You've got this weird issue.

At present it's difficult to give You any guideline but a place to start is
with the following article I wrote about troubleshooting:
http://www.excelkb.com/article.aspx?id=10206

You may also test if it will work by downloading and installing a patch from
MSFT:
FIX: Add-ins, smart documents, or smart tags that you create by using
Microsoft Visual Studio 2005 do not run in Office
http://support.microsoft.com/kb/908002/en-us

---------------
With kind regards,
Dennis
Weekly Blog .NET & Excel: http://xldennis.wordpress.com/
My English site: http://www.excelkb.com/default.aspx
My Swedish site: http://www.xldennis.com/

 

[AsimZia]

Hi Dennis,
Thanks very much for your reply , i have already done that patch
installation thing a month back, i will go through the link you have provided
me for troubleshooting.

Thanks and i will let you know as soon as i found something.

 

[AsimZia]

Hi Dennis,
I am still having the same problem, anything else you suggest me. It is
working fine on development machine but its not at all working test
machine/client machine, same error "Automation Error".


Thanks,
Asim.

 

[XL-Dennis]

Asim,

I re-read the thread and I started to think of VB 6.0 and why it works as
expected on Your machine but not on the test machine (without VB 6.0).

Do You have any references to external libraries or using certain ActiveX
components that are available on Your machine but not on the test machine?

A typical scenario is that we use version 2.8 of ADO Library with early
binding while on other machines we have an older version installed, i e
version 2.5. Or we have missed some component to be part of the installation
setup.

Is it possible for You to provide the main code for the connection in the
add-in?

BTW, have You tested to make a clean installation of the Add-in on Your
machine?
If You have 'shimmed' the COM add-in it will be loaded in its own AppDomain
and in that way You can test it.

---------------
With kind regards,
Dennis
Weekly Blog .NET & Excel: http://xldennis.wordpress.com/
My English site: http://www.excelkb.com/default.aspx
My Swedish site: http://www.xldennis.com/