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

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!



---
Regards,
Norman


wrote in message
oups.com...
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

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



---
Regards,
Norman

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




On 10 May, 15:11, "Norman Jones"
wrote:
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!

---
Regards,
Norman

wrote in message

oups.com...



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- Hide quoted text -

- Show quoted text -

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

wrote:

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

--

Dave Peterson