Deleting Query Tables with a Macro

So I have a spreadsheet that I import text files to every week for three months. At the end of the three months I have to go in and delete all of the data and the query that I have set up so that I can start over for three more months. I can import them via a macro just fine, but I cannot for the life of me figure out how to get the macro I recorded to delete them to work. I have tried three different macros with no success. The code is below. I would love some help.

The first macro I use creates a yes/no dialog box and calls the macro to delete the actual data and queries.

Please Login or Register  to view this content.

These are the two macros I have been unsuccessfully trying to get to work.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Here is a link to the workbook, if that will help.

http://www.4shared.com/file/59168046...V3AWESOME.html

Thanks for any help you can give me, because I am at a complete loss right now.

Clayton Grove

this should clear the contents. still working on the querytable part.

Please Login or Register  to view this content.

In an internet full of geniuses, you guys are the real mccoy!

Thanks for the help, and I am glad you got a chuckle out of the pictures!

Clayton Grove