I am currently using this to export 4 queries to one Excel workbook, but this takes roughly 5 minutes so I am searching to see if there are better solutions
Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "qryOne", "test1.xlsx", True, "A"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "qryTwo", "test1.xlsx", True, "B"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "qryThree", "test1.xlsx", True, "C"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "qryFour", "test1.xlsx", True, "D"