Simple Timer Help

[AshParr]

Hi,

I am looking for some that would allow me to use a simple timer to
save my worksheet.

I want the timer to run for a set amount of time, Say 30 seconds.

Then after that save the workbook.

Then repeat that process continually, is this possibly? (Basically i
just want to save my workbook after 30 seconds)

Please let me know,

Many thanks

Ash

 

[Norman Jones]

Hi Ash,

If you use Excel's AutoSave add-in, you can select
the save time

By the way, a save time of interval.30 seconds seems
somewhat OTT!

 

[Norman Jones]

Hi Ash,

I should have added that I do not use Excel's
standard Autosave addin.

I use, and highly recommend, the AutoSafe addin
from Jan Karel Pieterse. This addin may be
downloaded, free of charge at:

Downloads
http://www.jkp-ads.com/Download.asp

 

[AshParr]

thankyou for the reply,

but autosave is limited to 1 minute isnt it? the reason is i have real
time data wrote into a sheet & i was tinking of saving this file every
30 seconds so then another sheet can read it

 

[Dave Peterson]

Chip Pearson explains how to use application.ontime:
http://www.cpearson.com/excel/ontime.htm