Access 2000 to Excel

[William Allen]

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

[Technocrat]

I think we might need more code than that. It doesnt really show anything other than the fact you are running another macro and catching the errors.

[William Allen]

Nailed the problem!
The Excel workbook was on set to display 3 sheets in a new workbook. All three sheets currently had data on them so access would not delete any of the sheets to make room for the new one.
Thanks anyway to all who replied!