Autosave file after running macro

[prazad82]

Hello,


Is there a way to autosave (within 5 seconds) a file after a macro is run?


Thanks

 

[Debraj]

Yes.. there is a lots of way to save a file..

Application.AutoRecover.Time = 0.0833  (No less than 1 will not work.. :)

Application.OnTime Now + TimeValue("00:00:15"),...

but if you gives us what exactly you want.. then we can say that..

"You don't need to wait for 5 second.. you can add ThisWorkbook.Save at the end of the Macro.. just before End Sub"


Regards,

Deb

 

[prazad82]

Thank you very much