Deleting Linked Excel sheet

[BatmanMR287]

I have a database that links to an excel sheet and take data from it. For a fail safe i put deletes in several places in case of user error to make sure the sheet is deleted. If it is already deleted the other deletes don't act well.
I need to write a conditional iff statement that if it doesn't exist it ignores the delete call. Not sure how to structure it.

Private Sub Command3_Click()
DoCmd.DeleteObject acTable, "Sheet1"


DoCmd.Close acForm, "District Select Form"
End Sub

[June7]

Options:

1. error handler

2. loop through tables collection

3. On Error Resume Next

Review http://www.tek-tips.com/viewthread.cfm?qid=1070803

[BatmanMR287]

Can't read that site. Continuous popups on page keep me from reading it.

[June7]

Yeah, that was rather annoying. Had to avoid hovering cursor over posts. Kept off to the right side and scrolled. I managed to read enough to get the gist of content.

Do the Bing search and see what else there is.

[BatmanMR287]

Got it from the above page, after a few minutes the popups calm down.

Private Sub Form_Close()
On Error Resume Next
DoCmd.DeleteObject acTable, "Sheet1"
On Error GoTo 0
End Sub

This one doesn't care if the sheet is there or not. Thanks for the direction June 7.