VBA Code Excel Macro Examples Useful 100 Macros, Codes and How Tos explained Basic Beginners, Advanced users. Learn Excel 2003, 2007, 2010, 2013 Macros. In Access VBA, deleting Table can be done by Do. Cmd. Delete. Object Method. It is an extremely simple and straight forward, the syntax is as below. In order to delete Table, use ac. Table in the Object. Type argument. Do. Cmd. Delete. ObjectObject. Type, Object. Name.