Hi All - How do i get my vba macro to refresh every minute? I have a couple
of macros that are pulling data from the net and i want them to run
everyminute. How/What would i need to inset into the vba code to get it to
run every minute.

Thanks very much all.

Sam

Look at the OnTime function in VBA help.

--
__________________________________
HTH

Bob

"Sam" wrote in message
...
Hi All - How do i get my vba macro to refresh every minute? I have a
couple
of macros that are pulling data from the net and i want them to run
everyminute. How/What would i need to inset into the vba code to get it to
run every minute.

Thanks very much all.

Sam

Take a look at Chip Pearson's notes:
http://www.cpearson.com/excel/OnTime.aspx

Sam wrote:

Hi All - How do i get my vba macro to refresh every minute? I have a couple
of macros that are pulling data from the net and i want them to run
everyminute. How/What would i need to inset into the vba code to get it to
run every minute.

Thanks very much all.

Sam

--

Dave Peterson