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