Export to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

Can anyone tell me if there is answer to this question,
I want to export the results from 13 queries into 1 workbook but different
pages,
so that te data can then be used for other excel sheets. is this possible?
and if so how would I go about doing this?

TIA

Souchie40
 
Although Access Help says the Range arguement does not work on an export, in
fact, it does. (Can you imagine Microsoft Help every being wrong? :))
So, for each query, put the workbook and sheet name as your range argument:
"MyWorkbook!MySheetName"
 
Back
Top