I am running a report based on 4 queries. I was exporting each to its own Excel spreadsheet.
Now I want to export all 4 into one spreadsheet and combine all 4 on one tab.
Obviously the code below doesn't work - I think it's close, but needs a tweak.
Code: Select all
DoCmd.OutputTo acQuery, "SP-FAIR HOSPICE MEMBERS", "Microsoft Excel Workbook(*.XLSX)", _
R:\QRS HMOS 2022\ABC INC 2022\ & strMonth & "\HOSPICE REPORTS\QRS HOSPICE REPORT.XLSX\SHEET1", False, ""
DoCmd.OutputTo acQuery, "SP-XYZ FAIR HOSPICE MEMBERS", "Microsoft Excel Workbook(*.XLSX)", _
R:\QRS HMOS 2022\ABC INC 2022\ & strMonth & "\HOSPICE REPORTS\QRS HOSPICE REPORT.XLSX\SHEET1", False, ""
DoCmd.OutputTo acQuery, "SP-XYZ-FAIR HOSPICE MEMBERS", "Microsoft Excel Workbook(*.XLSX)", _
R:\QRS HMOS 2022\ABC INC 2022\ & strMonth & "\HOSPICE REPORTS\QRS HOSPICE REPORT.XLSX\SHEET1", False, ""
DoCmd.OutputTo acQuery, "SP-XYZ-FAIR HOSPICE MEMBERS", "Microsoft Excel Workbook(*.XLSX)", _
R:\QRS HMOS 2022\ABC INC 2022\ & strMonth & "\HOSPICE REPORTS\QRS HOSPICE REPORT.XLSX\SHEET1", False, ""