Auto run every 10 mins and save the file

[jimpatel1993]

Hi,

Can anyone tell me how to auto run specific code and save automatically every 10 mins since excel file open please?

Thanks a lot

[pjwhitfield]

Add the following Sub, (I've assumed the Sub you want to run is called "myCode", change it to your code name.

Please Login or Register  to view this content.

Then at the end of your code that you want to run add:

Please Login or Register  to view this content.

[jimpatel1993]

Hi
Thanks for your reply. This auto update once and code break next time (that is not doing anything after 10mins)

Any idea please?

Thanks a lot

[JEC.]

Put both TimerON and TimerOFF behind a button (place everything in a codemodule)
Or put the TimerOFF behind a workbook_close event

Please Login or Register  to view this content.

[pjwhitfield]

Hi
Thanks for your reply. This auto update once and code break next time (that is not doing anything after 10mins)

Any idea please?

Thanks a lot

Did you include the

Please Login or Register  to view this content.

within your existing code? Is it possible that the logic of your code means its not getting triggered?