automatically refresh macro

[Jim]

Do you know if it is possible to program a macro button
to automatically refresh once per day? My macro formula
is:
Range("y7").value=Range("x7").value
Range("x7").value=Range("w7").value
Range("w7").value=""

I would like this to occur once per day at approximately
5pm. Thanks for your help.

 

[Frank Kabel]

Hi Jim
you could use the OnTime method for this (see:
http://www.cpearson.com/excel/ontime.htm)

But why are you not using normal worksheet formulas like
=X7
and
=W7

 

[Jim]

I tried to use
=x7
and
=w7
however w7 is a stock quote web query and therfore x7
will take on the query and not the value. Perhaps there
may be another way to do this that I have overlooked?
Thanks again.