"Cannot Expand Named Range"

[JH]

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.

 

[JuneTheSecond]

This is the matter of Access or Excel?
You' would better to shift to the Access or Excel related forum.

 

[JH]

The code is VBA and this forum is VBA Development.

The error is an Excel error.
The command causing the error is being run within a module in Access.

So which forum should I post in ... Access or Excel ??

 

[JuneTheSecond]

This forum is Visio.VBA, you might get better information, if you find the
forum for Access.VBA or Excel.VBA.

JuneTheSecond