Can be the timer of autorecover of excel used to call a macro

[Levent Menteşoğlu]

Bir soruda ben sormak istiyorum.

Excelin otomatik kurtarma işlevindeki zamanlayıcıyı, zamana göre işlem yapan bir makronun çalıştırılmasında kullanabilirmiyiz?

Otomatik kurtarma --> Araçlar-seçenekler-kaydet

--------------------------------------------------------------------

I want to ask a question.

Can be the timer of autorecover of excel used to call a macro which is working according to the time.

Autorecover --> Tools-options-save

 

[Ivan F Moala]

Bir soruda ben sormak istiyorum.

Excelin otomatik kurtarma işlevindeki zamanlayıcıyı, zamana göre işlem yapan bir makronun çalıştırılmasında kullanabilirmiyiz?

Otomatik kurtarma --> Araçlar-seçenekler-kaydet

--------------------------------------------------------------------

I want to ask question.

Can be the timer of autorecover of excel used to call a macro which is working according to the time.

Autorecover --> Tools-options-save

Hi leventm, that's an interesting question.

I am not aware of a way, although in theory if you can detect when the directory where the autorecovered file is stored changes then you could run your macro OR
perhaps (Long shot) hook into the event that generates this ?

To see if a Dir / file changes see here
http://www.dailydoseofexcel.com/archives/2006/07/07/monitor-directory/#comments

But your question begs another one, why do you want to detect an autosave?

 

[Levent Menteşoğlu]

But your question begs another one, why do you want to detect an autosave?

Hi Moala

First thank you very much your answer

I had thought to use the timer of autorecover instead of a timer code which is working continuously