Please can you help me.

I was wondering how to transfer the result of queries to a specific range in an Excel worksheet. How to I do this, so that data already in Excel is not overridden by the result of my new query.

Specifying the range I want the result to go to in the argument section of the TransferSpreadsheet macro does not work.

Thanks.

See under Excel forum

Please see the following. I adapted the code for my db & it worked great !

http://www.mvps.org/access/modules/mdl0035.htm