[AccessD] Excel Automation problem

The problem may be that Access keeps putting your
references out of order. You'd need to make sure that
DAO36 is ahead of ADO##

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: "Cindy Fraase" <CFraase at officeimagesinc.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, April 20, 2007 12:40 PM
Subject: [AccessD] Excel Automation problem


> 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
>
>
>
> Cynthia Fraase
> Asst. Controller
> Direct: 678-325-3251
> Cell:     770-318-0628
> Fax:     770-641-2656
>
> www.officeimagesinc.com