Access 2000 VBA code not working Access 2002
The line of code that gave the error is Excel VBA, not Access.
Suggest you check Excel VBA Help on "CopyFromRecordset" and see if any
restriction on using it with automation. Also, test similar code (modified
to run in Excel by itself) in your Excel version.
--
HTH
Van T. Dinh
MVP (Access)
Quote:
> This line of code fails in the attached document:- "
> xlsheet.Range("a2").CopyFromRecordset dsource1 "
> This is the message generated:- " Class does not
> support automation or does not support excepted interface "
> Thanks.
> Aspiring Developer
