Auto Refreshing - values
 

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

Thanks



"Matt Lawson" wrote:

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

Auto Refreshing - values
 

Hi
this is what OnTime would do

--
Regards
Frank Kabel
Frankfurt, Germany

"Matt Lawson" schrieb im
Newsbeitrag ...
Can this procedure be run in the background so that it does not bog
down the
system?

Thanks



"Matt Lawson" wrote:

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