Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA- Time delaying macro
Hi. I'm working on a macro that will take a row of cells (coming in fro
live feeds), copy the values, and paste them one row down. I want t store 40 periods of data. I want to be able to enter the number o seconds that the code delays before repeating this process. I wa wondering if there is any time-delaying feature built into excel, an how to program it so that it starts when i hit a button, and stops whe i hit another button... The copying part is easy enough to program, but the time thing is wha is stumping me. Thanks for help -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA- Time delaying macro
You could look at incorporating an Ontime procedure driven by a button (look
in help). Another way would be to use the windows timer. I have an example that you can have if you email me. It has stop and start buttons. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "bsmith1 " wrote in message ... Hi. I'm working on a macro that will take a row of cells (coming in from live feeds), copy the values, and paste them one row down. I want to store 40 periods of data. I want to be able to enter the number of seconds that the code delays before repeating this process. I was wondering if there is any time-delaying feature built into excel, and how to program it so that it starts when i hit a button, and stops when i hit another button... The copying part is easy enough to program, but the time thing is what is stumping me. Thanks for help! --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA- Time delaying macro
This example pauses a running macro for approximately 10 seconds.
newHour = Hour(Now()) newMinute = Minute(Now()) newSecond = Second(Now()) + 10 waitTime = TimeSerial(newHour, newMinute, newSecond) Application.Wait waitTime ------------ That was copied directly from VBA help. Search for the 'wait' functio to find out more. -Gitcyphe -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA- Time delaying macro
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA- Time delaying macro
bob . phillips @ tiscali . co . uk
without the spaces -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "bsmith1 " wrote in message ... Bob, Could you tell me your email? Brian --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time dependant Excel Macro | Excel Discussion (Misc queries) | |||
Macro / function text time to 24hr excel time passed midnight fortotaling hr's | Excel Worksheet Functions | |||
How do I get a macro in excel to look at different data each time | Excel Discussion (Misc queries) | |||
excel - macro - automatic initiation of a macro at a pre-specified "system time" | Excel Programming | |||
Delaying calculations | Excel Programming |