Export To Excel .XLSX file

I currently export a query to an Excel File and then process it further with VBA.
I am not sure why, but for some reason Excel does not like the format of the file.
I am attempting to export as a XLSX file but can't seem to find any help on the internet that is specific enough to help me.
I currently make the Export in an Access Macro in an MDB Access DB.
I have now converted it to ACCDB and attempted to use the ExportWithFormat in the Macro without success.
So I went further to see what could be done with VBA in Access and came across the Transfer Spreadsheet DoCmd.
Here is the line that I created, that does not work.
[
DoCmd.TransferSpreadsheet(acExport, acSpreadsheetTYpeExcel12Xml, qryAddressPull-Step3-PrtPub, C:PCP\GMLSRC\EXCEL_REPORT_STUFF\Export-PrtPubList.xlsx)
]
-or-
[
DoCmd.TransferSpreadsheet(1, 10, qryAddressPull-Step3-PrtPub, C:PCP\GMLSRC\EXCEL_REPORT_STUFF\Export-PrtPubList.xlsx)
]

- or with quotes -

[
DoCmd.TransferSpreadsheet(acExport, acSpreadsheetTYpeExcel12Xml, "qryAddressPull-Step3-PrtPub", "C:PCP\GMLSRC\EXCEL_REPORT_STUFF\Export-PrtPubList.xlsx")
]
-or-
[
DoCmd.TransferSpreadsheet(1, 10, "qryAddressPull-Step3-PrtPub", "C:PCP\GMLSRC\EXCEL_REPORT_STUFF\Export-PrtPubList.xlsx")
]

Any help would be greatly appreciated.
Thank you,
Dan Foltz