Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel "web query" timeout
I have a problem with web query.
I create an excel sheet, retrieving web data. generally, it work well, but sometimes, it take a longer time to complete the process. I check the time: 1. generally, it take 5~10 sec. 2. sometimes, when internet or link is error, it will take 21~24 sec. (seem like some timeout constant) and return an error. 3. But only some exceptional cases, the query waiting for several minute (more than 5 min) to return back to excel with data. In case 1 and 2, I can handle it, but in case 3, I don't know how to handle it. Only let the program halting and waiting for the reture. It seem not work. If I can set a timeout for web query, it may help. Do you have some suggestion, please help. Best regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"edit query" button in Excel 2007 has been hidden | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Any good resource to learn Excel Web Query ".iqy" Files? | Excel Discussion (Misc queries) | |||
Query Table "Connection" Prevents Excel from Quitting | Excel Programming | |||
Connection with SQL Server generate "Timeout expired" | Excel Programming |