Automatic Workbook Saving

Giles-UK · Mar 6th, 2002, 09:16 AM

I posted this earlier today but it hasn't appeared as yet so I'll try again..

Can someone help me in setting up some simple code that does the following:- After 20 minutes (or so) after I last saved a file i want excel to throw up a dialogue box that says "Do you want to Save this Workbook?" YES/NO. If i hit yes it simply does a save as...and doesn't adk for another twenty mins.

I know that there is an autosave feature on excel but this doesn't ask if you want to so you could overwrite something you don't want to.

I have just started learning about VBA but I don't reckon it will be too hard to do!!!

Thanks in advance
Giles in the UK

Paul B · Mar 6th, 2002, 09:24 AM

Auto save has a prompt before save, In excel '97 anyway

Steve Hartman · Mar 6th, 2002, 09:28 AM

Excel 2000 does too.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 09:16 AM	#1
Giles-UK New Member Join Date: Mar 2002 Location: Giles - UK Posts: 1	I posted this earlier today but it hasn't appeared as yet so I'll try again.. Can someone help me in setting up some simple code that does the following:- After 20 minutes (or so) after I last saved a file i want excel to throw up a dialogue box that says "Do you want to Save this Workbook?" YES/NO. If i hit yes it simply does a save as...and doesn't adk for another twenty mins. I know that there is an autosave feature on excel but this doesn't ask if you want to so you could overwrite something you don't want to. I have just started learning about VBA but I don't reckon it will be too hard to do!!! Thanks in advance Giles in the UK

Mar 6th, 2002, 09:24 AM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Auto save has a prompt before save, In excel '97 anyway

Mar 6th, 2002, 09:28 AM	#3
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Excel 2000 does too.