I have a process that I support that has started generating an error.

This process imports a spreadsheet from Excel into Access. It then runs
queries to split the data into individual accounts and then it exports the
split up data back to Excel using the following command:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3, "Temp55a",
strLoc, True

83 Spreadsheets of 86 get created.
The 84th spreadsheet fails with error number 3434 - Cannot expand named range.
Once the error is encountered the database closes with the process unfinished.

I am completely baffled by this. There is NO named range in the command.

The parameters break down to action type (acExport), Excel version
(acSpreadsheetTypeExcel3), Access table name (Temp55a), File Name (strLoc),
Column headings (True).

I have searched extensively trying to find an answer to this issue with no
luck. In fact, I have not even seen anyone else having a similar issue.

Any help would be greatly appreciated.