-
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
-
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.
-
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!
