VBA If Statement

[BatmanMR287]

I need an If statement for this vba line in an access database.

DoCmd.DeleteObject acTable, "Sheet1"

Sometimes "Sheet1" is not there and without the If statement it pops up an error window. Apparently I am writing it wrong.

[June7]

Why delete table?

Bing: Access VBA verify table exists

http://www.eraserve.com/tutorials/MS...ble_Exists.asp

http://stackoverflow.com/questions/3...-for-vb-macros

[BatmanMR287]

Opps, sorry June7. I should have said it is actually a linked Excel file. Deleting it from the access database severs the link.

[June7]

Example code should be adaptable.

[DubCap01]

You could also try this, it works on any of my bits of VBA...

On Error Resume Next
CurrentDb.Execute "Drop Table Sheet1", dbFailOnError
'and here comes the rest of your code...