Here is the line of code I am using. I have never been able to save this to any type but .xlsb which is chosen because it will not let me use .xlsx in the filename parameter...
EDIT: Ahh.. apparently the "xml" at the end of the acspreadsheettypeexcel12 parameter, allows for .xlsx. Thanks , I did not know that. That will be useful for possibly replacing data in an existing table I think.
Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qry_BUILD_REPORT", "\\redactedservername\Programs\(..Scorecard\Cycle time\RAW DATA\" & "PASTE_DATA_INTO_REPORT", True, "YTD DATA"