I have an access 2000 macro that exports a table to an excel spreadsheet. The macro worked fine for a while but now it just halts and gives me the message "Cannot delete spreadsheet cells"
simple code:
Private Sub cmdTransfer_Click()
On Error GoTo Err_cmdTransfer_Click

Dim stDocName As String

stDocName = "transfer"
DoCmd.RunMacro stDocName

Exit_cmdTransfer_Click:
Exit Sub

Err_cmdTransfer_Click:
MsgBox Err.Description
Resume Exit_cmdTransfer_Click

End Sub
Can anyone help?
Thanks in advance
Bill