I am trying to export 4 reports to excel so all reports got to one workbook and uses 4 tabs/worksheets. I can use the following for a table/query and it works great i get the tabs/wooksheet.
DoCmd.TransferSpreadsheet acExport, , "90JJ AR by Rej", "C:\Documents and...