Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Office button, how to remove excess files no longer needed | Excel Discussion (Misc queries) | |||
How do I delete the name for a named range i no longer require? | Excel Worksheet Functions | |||
Row/Column Delete taking longer time | Excel Discussion (Misc queries) | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
How do I stop using data source no longer needed for charts? | Charts and Charting in Excel |