Excel (with autosave 15') reopens after closing it

[jonas-martens]

All,

I have a document with an autosave on it, it saves every 15min.
Now is the problem :
When i close the excel file, it reopens and saves again. It remains open as well.

Can somebody help me how to get out of the autosave loop when the document is closed?

This is my autosave code :

Please Login or Register  to view this content.

[cytop]

You need to cancel any active timers - otherwise Excel will reopen the workbook when the timer next fires. The timer is an Application event so is unaffected by the workbook closing.

To cancel a timer, you call the OnTime event passing the exact time the timer is next due to fire and adding False to indicate the timer is to be cancelled when you are finished with the timer or the workbook is closed.. This means you have to store the time somewhere

[jonas-martens]

Thanx.

But i'm not an excel expert...
So can you tell me how do i practically do this?

[cytop]

Timers are explained fully, and simply, here

[jonas-martens]

Thanx!
Problem solved