When you use Microsoft Data Access Objects version 3.0 (DAO 3.0) with
Microsoft Excel 97, you may receive the following error message:
Run-time error '430':
Class doesn't support Automation
Back to the top
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.
Back to the top
Change your project in Microsoft Excel 97 so that it references DAO 3.5
instead of DAO 3.0:
| 1. | In the Visual Basic Editor, click References on the Tools menu.
|
| 2. | Clear the "Microsoft DAO 3.0 Object Library" check box.
|
| 3. | Select the "Microsoft DAO 3.5 Object Library" check box and click OK. |
Back to the top
