Autosave every 15 minutes

[mania112]

I have this code, and it's not working:

Please Login or Register  to view this content.

Can someone help me setup an autosave vb in Excel 2007 - I want a SAVE not a SAVE AS.

thanks

[Andy Pope]

What's wrong with the built-in autosave?

Your code has an extra End Sub

Please Login or Register  to view this content.

[mania112]

the built in autosave in 2007 is autorecovery? and doesnt work the same way - i thought?

[Andy Pope]

Yes, my bad. I should have read the description more closely.

Does removing the End sub from your routine help.

[Andy Pope]

Have you tried Jan Karel's Autosave addin?
http://www.jkp-ads.com/Download.asp

[mania112]

yeah it seems to be working ok, guess i'll find out in 15 minutes!

does this remove the option to save when i close excel?

this code:

Please Login or Register  to view this content.

i changed Time from Now, is there a difference here?

[Andy Pope]

You can unset the Saved flag after saving.

Please Login or Register  to view this content.

Time does not contain any date information so not sure what would happen at 23:45 or later. Whether the TIME+15 will automatically work.
Perhaps not as this in the immediate window would suggest the next schedule is way in the past.

Please Login or Register  to view this content.

[mania112]

so you think a 'now' + 15 would be the prefered method

If i'm only accessing this file between 830 and 1600 i suppose it wouldnt matter about autosaving into a new day?

[Andy Pope]

Be safe and use NOW

[mania112]

roger that, thanks for the help