[AccessD] Excel Automation problem

Hi All,
I finally got back to the computer that was having trouble. The
references were in the same order, so that wasn't it. But I simply
reregistered the DAO360 dll and everything works again! I thought I'd
post this in case anyone else runs across the problem.
Cindy

 
 
 
Cynthia Fraase
Asst. Controller
Direct: 678-325-3251
Cell:     770-318-0628
Fax:     770-641-2656
 
www.officeimagesinc.com
 
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, April 20, 2007 12:55 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Excel Automation problem

Hi Cindy

It could be an MDAC versions mis-match:

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

/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



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com