Access with Excel Code Question

[foxhound]

Hello,

I am using access code to delete "sheet1" in an Excel workbook. How can I adapt the code below to suppress the delete confirmation box?

Private Sub Form_BeforeDelConfirm(Cancel As Integer, _
Response As Integer)
' Suppress default Delete Confirm dialog box.
Response = acDataErrContinue
End Sub

 

[LTunnicliffe]

Try something like:

xlApp.DisplayAlerts = False
'Delete Sheet1
xlApp.DisplayAlerts = True

Hope this helps!

 

[foxhound]

Loren,

Again, that was exactly what I was looking for. Thank you so much!