Call every X seconds

[frubeng]

Is there a way to have a Sub called every X second withOUT doing a continuous loop? For example, i would like a workbook that saves itself every 1 second?

Any help is appreciated! :bow:

Thanks.

[Bob Phillips]

I don't get it, if you are in a loop, you can call it directly from there, so why do you need the every X seconds as well?

[frubeng]

Sorry, I meant that I don't want to be in a loop. If i have a loop running all day, my excel is used up, I would just like it to call itself every X seconds...

[mdmackillop]

http://www.cpearson.com/excel/OnTime.aspx

[frubeng]

http://www.cpearson.com/excel/OnTime.aspx

Great, thanks a lot!