I am using MS Access 2003/2007.
I understand that there is an Output To macro that will export selected queries into an Excel (xls, xlsx) format to a specific path that can be converted to vba:
DoCmd.OutputTo acOutputQuery, "QueryName", "ExcelWorkbook(*.xlsx)"...