Hi All,
I know how to output data to an Excel workbook using:
DoCmd.OutputTo acQuery, "Qry-Report", "MicrosoftExcel(*.xls)", "C:\Output.xls", False, ""
But is it possible to output to a specific worksheet within the workbook?
Thanks,
Ian
I know how to output data to an Excel workbook using:
DoCmd.OutputTo acQuery, "Qry-Report", "MicrosoftExcel(*.xls)", "C:\Output.xls", False, ""
But is it possible to output to a specific worksheet within the workbook?
Thanks,
Ian