If you see Microsoft Visual Basic, Run-time error, Class not registered in Office Excel, follow these solutions that have helped many fix the issue.

AFAIK the DoCmd.RunSQL is only used for "action" queries such as append, delete, etc. <BR>To achieve what you want, you'll need to create a new recordset based on your SQL statement.