D
D.L.
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
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