Article ID: 157436
Article Last Modified on 10/10/2006
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q157436
For a Microsoft Office XP version of this article, see 291301.
For a Microsoft Excel 2000 version of this article, see 213577.
SYMPTOMS
When you use Microsoft Data Access Objects version 3.0 (DAO 3.0) with Microsoft Excel 97, you may receive the following error message:
CAUSE
You will receive the error message given above if both of the following are true:
- You are referencing the DAO 3.0 object library.
-and-
- You are using the CopyFromRecordset method in your macro.
This behavior is by design of Microsoft Excel.
RESOLUTION
Change your project in Microsoft Excel 97 so that it references DAO 3.5 instead of DAO 3.0:
- In the Visual Basic Editor, click References on the Tools menu.
- Clear the "Microsoft DAO 3.0 Object Library" check box.
- Select the "Microsoft DAO 3.5 Object Library" check box and click OK.
Additional query words: XL97 8.00 Run-time error 430 Class doesn t support Automation
Keywords: kbbug kbdtacode kberrmsg kbpending kbprogramming KB157436