The only real pitfall is that the workbooks from which you read data
should be closed. if they are open, this leads to memory leaks and
crashes.

There are several good sites for learning to work with excel and ADO

Good samples:
www.erlandsendata.no

Good reference on all ado objects and methods:
http://www.devguru.com/Technologies/...ado_intro.html

lot's of documentation on connection strings:
http://www.able-consulting.com/ADO_Conn.htm


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"?B?TUs=?=" wrote:

Have done some VBA/Access work, new to VBA/Excel

Would like to run queries (SQL) using Excel ranges and return the
results to a new spreadsheet. Are there any pitfalls I should be
aware of before I get started ?

Thanks,
Mike