cannot expand name range error 3434

Question

Hi Everyone,

HAs anyone came across this error "cannot expand name range" error Number 3434 when using DoCmd.TransferSpreadsheet acExport

THis is my line of code that causes the issue

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "ExceptionRNS", CurrentProject.path & "" & "myexportedfile" & Format(Now(), " mm dd yyyy"), True

I have no idea what is not working ..the table "ExceptionRNS" is populated

any thoughts?

Answer 1

Because this problem is related primarily to Excel, you might get more visibility by posting it in an Excel forum.

That said, the problem is likely that the Named Range in the Excel worksheet has fewer rows designated than our export is trying to insert. Search for "Dynamic Named Range".