Auto Refreshing - values

[Guest]

I am using a web query to retreive data from a webpage.

This data needs to be constantly updated, and there is an option for this.

However, the filename changes every hour.

I can generate a filename based on the current time (using the =NOW()
command).

I recorded a macro setting up the web query and found I could make it part
of a macro also (that is, input the filename as a variable.)

However, the real problem I just discovered is as such:


How do I refresh the =now() statement every 5 minutes or so, that way the
correct file names can be generated?

Any ideas?

Thanks

Matt Lawson


Thanks,

Matt Lawson

 

[Frank Kabel]

Hi
try using the OnTime Method in VBA:
http://www.cpearson.com/excel/ontime.htm

 

[Guest]

Can this procedure be run in the background so that it does not bog down the
system?

Thanks

 

[Frank Kabel]

Hi
this is what OnTime would do