hi, i had a problem to export queries result into spreadsheet. I know if i use transfer spreadsheet in access, all the queries result will put into diff worksheets. But i would like to write a macros so that all the queries will put under one spreadsheet. Can this be done?

Let say 1st query will output to excel worksheet in column A1 and B1, and the 2nd query will output to C1 and D1. How can i do this? i really stress on this..:(