Runtime Error 3435

[Bonediggler1]

Hi-

I am getting runtime error 3435 "Cannot delete spreadsheet cells.", about which there appears to be very little documentation available!

This occurs during a TransferSpreadsheet action that has been in error-free use for several years.

There is nothing wrong with the workbook being written to, it is not protected, etc.

The code is:

DoCmd.TransferSpreadsheet acExport, 8, "REJECTS", direct & "REJECTS - " & frm & ".xls", True, ""

Thank you!

 

[lameid]

Are you sure there are no problems with the data itself... No #Error displayed in the query?


Assuming you are exporting to a new file, the first thing I would try is using criteria to export less and less data until it will export. Through testing you will hopefully be able to tell which record(s) are giving you trouble and then figure out why they are causing a problem.

Also you should validate you can export to Excel without using code. If you can't, the Excel ISAM driver is likely corrupt and needs reinstalled.

 

[Bonediggler1]

One more thing: the application is in Access 97 (it can't be converted for some reason).

I am waiting to get a copy of 97 to try and troubleshoot, though I don't think it has to with size of the data (there are only about 15 records).

It is also exporting from a table rather than a query, that has no errors.

I'll follow up after troubleshooting.

Thanks for the help!

 

[TheAceMan1]

How are ya Bonediggler1 . . .

What are the two items in red suppose to return and what are there datatypes?

[blue]DoCmd.TransferSpreadsheet acExport, 8, "REJECTS", [red][b]direct[/b][/red] & "REJECTS - " & [red][b]frm[/b][/red] & ".xls", True, ""[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Bonediggler1]

"direct" is a variable specifying the path where the spreadsheet should be copied. "frm" is a variable for the form name, which is the same as the customer name in question.

(I didn't write this code)

 

[lameid]

If you have A version of Access later than 97 you should be able to convert it to a newer format for testing purposes.... You'll just have to make the changes in Access 97 or convert it back. Remember Access 97 does not support ADO!

Or maybe you can't convert an Access 97 database in 2007? Any version through 2003 can.