I have a macro that refreshes data (pulling it in form XML or Excel files).
Since I want to delete the old files first, I also have a DeleteObject for each of the old tables.
However, sometimes, the old table is not there (maybe I deleted it manually, or it was the ImportErrors table, or some other reason it is not there this week).
Can I make an If statement that says something like:
If Table xyz is present, then
DeleteObject, Table xyz, else
Skip this step in the Macro
I am using Access 2010
Since I want to delete the old files first, I also have a DeleteObject for each of the old tables.
However, sometimes, the old table is not there (maybe I deleted it manually, or it was the ImportErrors table, or some other reason it is not there this week).
Can I make an If statement that says something like:
If Table xyz is present, then
DeleteObject, Table xyz, else
Skip this step in the Macro
I am using Access 2010