Remove all connections?

Hello all - I've got a little program which uses webqueries to import data from anywhere between10 and 200 web pages. It's working pretty well, but I need a way to clear out the residual connections via the code.
The part of the macro which imports the data was simply recorded and very slightly modified. I've included it below... but what I'd like to do once the data has been imported is delete the connection. Any ideas are appreciated.

Please Login or Register  to view this content.

THANKS!

Perhaps something along the lines of:

Please Login or Register  to view this content.

most likely each time you Refresh a new QueryTable will be added to the QueryTables collection and you most likely have a Defined Name created for each instance also... you may want to purge those too.

insert

Please Login or Register  to view this content.

at the end.