Transferring results of queries to Excel

[LJ]

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.

 

[Twin]

See under Excel forum

 

[diversoln]

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

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