[AccessD] Excel Automation problem

Gustav Brock Gustav at cactus.dk
Fri Apr 20 11:54:55 CDT 2007


Hi Cindy

It could be an MDAC versions mis-match:

http://search.msdn.microsoft.com/search/Default.aspx?brand=msdn&locale=en-us&query=430+Class+does+not+support+Automation+or+does+not+support+expected

/gustav

>>> CFraase at officeimagesinc.com 20-04-2007 18:40 >>>
Hi all,
I'm really mystified as to what is happening. The following line of code
works fine on my machine, but fails with this error on another. Both
machines are running Access 2003 and all of the references match. The
database is in Access 2002-3 format. It's located on the server, so I'm
running exactly the same database as he is.

I've created an Excel sheet via automation and am filling it with data
here.

The line is: 

objSheet2.Range("A2").CopyFromRecordset rsSalary

The error message I get is:
 430 Class does not support Automation or does not support expected
interface.

Any insights would be greatly appreciated!

Thanks,
Cindy






More information about the AccessD mailing list