Deleting Web Queries

[klatlap]

Hi all, i have an issue, i collect data from a site and each page is associated with a url that contains a date, the problem i have is i am getting data that is stuck on one date, it's not clearing the old data even if i clear it and change the date.

 

[John_w]

This deletes all web queries (but not the data) on the active sheet:

    With ActiveSheet
        While .QueryTables.Count > 0
            .QueryTables(1).Delete
        Wend
    End With

 

[klatlap]

cheers, i will give it a try.