Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hi All - How do i get my vba macro to refresh every minute?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hi All - How do i get my vba macro to refresh every minute?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hi All - How do i get my vba macro to refresh every minute?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I set up a lag in a macro (like a two minute lag)? | Excel Discussion (Misc queries) | |||
refresh macro | Excel Discussion (Misc queries) | |||
refresh macro | Excel Worksheet Functions | |||
Refresh macro | Excel Discussion (Misc queries) | |||
convert time from 60 minute hour to 100 minute hour | Excel Discussion (Misc queries) |