Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! Query table refresh hangs excel
Hi,
I am writing a component which uses the QueryTable to get data from a url (an asp page) and put it into a worksheet in a work book. This it does in a loop to fill 17 worksheets based on some criteria. This works fine on my local but very erratically on the live server which is a windows 2003 machine. On the server it just hangs for some of the reports I am trying to create. I used a log file to debug and realised it hangs at this line of code oQueryTable.Refresh(false); Its like the control never comes back to the component. I just don't under stand whats going on here. Why does the web query hang sporadically when it works just fine on my machine? Any help would be really appreciated. I am at my wits end! Thanks, Juhi. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query - Add Table - Hangs/Not Responding | Excel Discussion (Misc queries) | |||
Code To Refresh Query Table | Excel Discussion (Misc queries) | |||
How do I get a web query to auto-refresh before a pivot table aut. | Excel Discussion (Misc queries) | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming |