Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Increasing the Data Refresh rate for Web Queries for Excel 2002
I have Excel 2002 and I am an admitted novice at programming of any
type I use a Web Query to download live data from a website which I use the data for calculations. Unfotunately for me Excel only allows refreshes of minute or more through it's menu setting after the query is made by selecting: DATA IMPORT EXTERNAL DATA DATA RANGE PROPERTIES... and check the "Refresh Every" and chose the time in minutes. I say unfortunately because I need a much faster data refresh rate, more like every 5 seconds instead of a whole minute. No... the menu selection doesn't take decimal numbers. I was wondering if it's possible to program a faster refresh rate for Web Queries? Does anyone know? If so please make a simple example for a novice like me. Thanks -DM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SPSS QUeries in Excel and refresh data | Excel Discussion (Misc queries) | |||
Excel 2002 External Data Queries and UNC !HELP! | Excel Discussion (Misc queries) | |||
Data Refresh Issues when linking Access queries to Excel | Excel Discussion (Misc queries) | |||
Specifying table in Excel 2002 web queries | Excel Discussion (Misc queries) | |||
Refresh rate in getting external data from file | Excel Programming |