External Table is not in the expected format - ms access 2013

[PeteB23]

Hi. I am running the following vb command from access 2013.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "123", "c:\test\test.xls", True

Access 2013 - Excel 2013

The table 123 is created but the external table is not in the expected format appears and when I click on debug, the command line above is highlighted.

Any suggestions / ideas would be greatly appreciated.
Thank you!

 

[PeteB23]

UPDATE: The above ONLY works when the template file test.xls is already open. Then the output of table 123 will export to excel with no issues. Please help!! I would like this to work with the test.xls closed as a script exists to create a number of files.

 

[stumac]

Could you be running into this issue:

https://docs.microsoft.com/en-us/office/troubleshoot/access/import-export-access-to-excel

Looks like workarounds are to change the file type or open the file first.