AutoSave with New File Name xls 2003

I've seen past posts that discuss saving to specific locations, or saving with a new file name that adds the date.

I'm working with a file that I'd like to back up every x minutes. It may be 5 mins, it may be 30 - not sure. I thought there was an addin floating around that would do the following:

1. AutoSave (not save AutoRecover info) a document with no prompt confirming save.
2. Change a specific component of the file name:
-I save my files as "Main File Description 1-10-08 v1.xls". I want the addin to change just the v1 part. Every time the file saves, it will save a new version. So, if I open v1, in 10 minutes (for example), it will save (creating a new file) v2. After 20 minutes of being open, it saves v3. And so on. It would automatically adjust the date as well, so if I am working overnight, it would go from ...1-10-08 v23 to ...1-11-08 v1.

I don't want to come across as asking for someone to write this for me in vba, etc - I thought that I had seen this online before and couldn't find it when trying to search for it yesterday. If you know where it is, I'd appreciate the direction.

And if you're one of those types who likes a challenge and is of a particularly generous nature, and you want to write this - I won't complain.

Thanks

Excellent! Thanks - will give this a shot and follow up.

alright, may have done this wrong - I inserted the code into the "ThisWorkbook" page under "Microsoft Excel Objects."

Then I did Insert>Module and pasted the second code in that. Then clicked save.

Went back to the excel file and clicked Insert>Name>Define> and typed in SaveInterval - which changed the name of cell A1 (the highlighted cell) to SaveInterval. I then entered into that cell =5.

I would suspect that after 5 minutes, I would have a second file where my first one was saved, with the v# changed. Did I put the code in the wrong spot in the VBA editor?