How to delete a web query when it's no longer needed?
Hi, All -
I have an application that uses a web query to retrieve stock quote
data. The query is created by a VBA program which looks up a ticker
list and builds the URL query string for the tickers in the list.
Strangely, I've found that if I leave the query sitting in the
spreadsheet, sometimes it starts to consume 100% CPU resources even if
I state add ".RefreshPeriod =0" to keep it from trying to update
itself.
Is there a way to get rid of the query object itself while keeping the
data it returned?
TIA,
David
|