Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
timer within a macro
Hi Jonathan,
I think you have to use ON.TIME function. See this link of Chip Pearson http://www.cpearson.com/excel/ontime.htm HTH -- (So that you get best and rapid solution and all may benefit from the discussion, please reply within the newsgroup, not in email) "Jonathan" escreveu na mensagem ... if I have a macro that opens a file and then another two perform a function once a condition is met how do I do it? When the first macro runs it updates (via a dde link) and takes a while to update. when fully updated a check cell changes from value 0 to 1. When it turns to 1 I want the second macro to run. any way to do this? Perhaps a loop that keeps checking the status of the check cell? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
timer within a macro
SetLinkOnData can be used to trigger a macro when a DDE link changes.
Ontime, as Orlando has said, is used to run a macro after a set amount of time has elapsed. It sounds like Ontime has a role to play, but your challenge appears to be initiating the ontime setting. -- Regards, Tom Ogilvy "Jonathan" wrote in message ... thanks, but I don't think that is what I am looking for. Was more looking for some type of code that said if a cell does not equal a certain value, wait ten seconds, if it does then run another macro. -----Original Message----- Hi Jonathan, I think you have to use ON.TIME function. See this link of Chip Pearson http://www.cpearson.com/excel/ontime.htm HTH -- (So that you get best and rapid solution and all may benefit from the discussion, please reply within the newsgroup, not in email) "Jonathan" escreveu na mensagem ... if I have a macro that opens a file and then another two perform a function once a condition is met how do I do it? When the first macro runs it updates (via a dde link) and takes a while to update. when fully updated a check cell changes from value 0 to 1. When it turns to 1 I want the second macro to run. any way to do this? Perhaps a loop that keeps checking the status of the check cell? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
timer within a macro
the real issue I am facing is how to trigger the macro to
run WHEN a condition in a cell is met. -----Original Message----- SetLinkOnData can be used to trigger a macro when a DDE link changes. Ontime, as Orlando has said, is used to run a macro after a set amount of time has elapsed. It sounds like Ontime has a role to play, but your challenge appears to be initiating the ontime setting. -- Regards, Tom Ogilvy "Jonathan" wrote in message ... thanks, but I don't think that is what I am looking for. Was more looking for some type of code that said if a cell does not equal a certain value, wait ten seconds, if it does then run another macro. -----Original Message----- Hi Jonathan, I think you have to use ON.TIME function. See this link of Chip Pearson http://www.cpearson.com/excel/ontime.htm HTH -- (So that you get best and rapid solution and all may benefit from the discussion, please reply within the newsgroup, not in email) "Jonathan" escreveu na mensagem ... if I have a macro that opens a file and then another two perform a function once a condition is met how do I do it? When the first macro runs it updates (via a dde link) and takes a while to update. when fully updated a check cell changes from value 0 to 1. When it turns to 1 I want the second macro to run. any way to do this? Perhaps a loop that keeps checking the status of the check cell? . . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
timer within a macro
Thanks for all your help, however still not working.
The calculate event is for when data changes in a chart accordign to my book. Not sure what you mean. I tried doing an infinite loop until the condition was met but it put the DDE updating on hold so didnt woark. In summary, this is what I am trying to do: a spreadsheet opens, DDE links start updating. I have a cell that turns to "1" if the calculations are complete and no errors and "0" if stillupdating or complete (i.e., fully updated) but with errors. Once this turns to "1" I want to start another macro. I actually have a macro from another file that opens the file in question. what I would like to do is append to that macro a mechanism to start the other macro once the "1" condition is met. Any additional help would be greatly appreciated. Thanks again./Jonathan -----Original Message----- use the calculate event and test for the condition. Regards, Tom Ogilvy Jonathan wrote in message ... the real issue I am facing is how to trigger the macro to run WHEN a condition in a cell is met. -----Original Message----- SetLinkOnData can be used to trigger a macro when a DDE link changes. Ontime, as Orlando has said, is used to run a macro after a set amount of time has elapsed. It sounds like Ontime has a role to play, but your challenge appears to be initiating the ontime setting. -- Regards, Tom Ogilvy "Jonathan" wrote in message ... thanks, but I don't think that is what I am looking for. Was more looking for some type of code that said if a cell does not equal a certain value, wait ten seconds, if it does then run another macro. -----Original Message----- Hi Jonathan, I think you have to use ON.TIME function. See this link of Chip Pearson http://www.cpearson.com/excel/ontime.htm HTH -- (So that you get best and rapid solution and all may benefit from the discussion, please reply within the newsgroup, not in email) "Jonathan" escreveu na mensagem ... if I have a macro that opens a file and then another two perform a function once a condition is met how do I do it? When the first macro runs it updates (via a dde link) and takes a while to update. when fully updated a check cell changes from value 0 to 1. When it turns to 1 I want the second macro to run. any way to do this? Perhaps a loop that keeps checking the status of the check cell? . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
timer Macro | Excel Worksheet Functions | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
Adding A "Timer" to a Macro | Excel Worksheet Functions | |||
timer macro | Excel Discussion (Misc queries) | |||
Macro With Timer Event | Excel Discussion (Misc queries) |