Delete Querry Table Report using wildcard

In order for me to create a filter list on my worksheet, I'm having to first delete
a querry report that's being stored/generated from the data being imported into my
workbook.
Due to Run-Time Error'1004

A list cannot overlap a range that contains a pivotTable report,query results,protected cells or another list.

Initially, I only had 1 ActiveSheet.QueryTable to delete ("IN Stock Status Report - 6896_12"), but this also changed when I ran on another PC under someone else's account.

I'm hoping that maybe I can use a wildcard "in the sense" to delete all occurrences that
may appear.

The following are macros recorded to log what's needing to be deleted.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I'm hoping for something like this:

ActiveSheet.QueryTables("IN Stock Status Report - 6896_*").Delete
..but that does not work.

Here's a bit of code that brings in the querry report.

Please Login or Register  to view this content.

Any help is appreciated.

Thanks,

BDB

I may should have titled this thread as,"Delete or remove external data connections"

Since my data is brough in by a query, I need to disassociate the sheet with the query in order to add a list.

...Maybe I should just say.. while attempting to create my list, I get a msg box stating:"Your selection contains one or more external data ranges.
Do you want to convert the selection to a list and remove all external connections?"

After selecting "Yes" my list is made. I'd like to be able to do this automatically through a macro

Hope this makes sense.

BDB

Hi all,

...just want to share my latest resolvement.


The following code deletes all queries within a workbook.
I found the code here: http://www.*****-clicks.com/excel/ExternalData4.htm

Please Login or Register  to view this content.

This seems to have fixed my problem w/o having to use a (*) to define/name each querry table link needing to be removed.
Now I can build my filter list w/o any manual manipulation/ interruption.

Regards,

BDB