From Excel:

Tools Options Save check autosave and set the time to 15 minutes.

From VBA:

Application.AutoRecover.Time = 15

This avoids having to use an OnTime Event macro
--
Gary''s Student - gsnu200762


"Priyanka" wrote:

Hi

Can someone help me with the code to save an excel worksheet every
fifteen minutes? I will need some sort of a sleep command - what can I
use in excel? What is the syntax?

Thanks a bunch
Priyanka