P
papou
Hi all
I run a number of queries and save each of them in an Excel workbook using
the following method:
DoCmd.OutputTo acOutputQuery, "Rq_Doublons", "MicrosoftExcel(*.xls)", "",
False, ""
This is rather convenient since it shows the SaveAs dialog box when the
filename is empty
this works fine but now I would like to export these queries to a unique
Excel workbook (or at least have the choice for my users)
ie: n queries = n sheets in 1 workbook
How can this be achieved without OLE?
Could I do this using my method, but then how can I retrieve the name and
place chosen from the dialog?:
Or should I use the Docmd.TransferSpreadSheet? but then how?
Any help much appreciated
Regards
Pascal
I run a number of queries and save each of them in an Excel workbook using
the following method:
DoCmd.OutputTo acOutputQuery, "Rq_Doublons", "MicrosoftExcel(*.xls)", "",
False, ""
This is rather convenient since it shows the SaveAs dialog box when the
filename is empty
this works fine but now I would like to export these queries to a unique
Excel workbook (or at least have the choice for my users)
ie: n queries = n sheets in 1 workbook
How can this be achieved without OLE?
Could I do this using my method, but then how can I retrieve the name and
place chosen from the dialog?:
Or should I use the Docmd.TransferSpreadSheet? but then how?
Any help much appreciated
Regards
Pascal