Version Control

Hello Everyone

This is my first post and I am a medium knowledge user of Excel.

At my workplace there are a few of us around the building who all need to access a spreadsheet held on our server. A problem occured at the weekend with someone using an old copy, saving it, and it overwrote the newest version.

What I am after is a way of giving the spreadsheet a version number.
Incrementing that version number by one everytime its saved.
Storing that version number on the server in another file.
When anybody opens the speadsheet it automatically checks against that version number to make sure its the newest version.
If it doesnt it tells them to update their spreadsheet and quits.

All help would be appreciated
Ti

Hi All

We have sorted the problem to recover the spreadsheet we need. But to stop it ever occurring again what I`m after is putting a version number into a cell on workbook (easy).

Incrementing that number by 1 when the save button is pressed (I dont know how to do that).
Storing that number in a text/xml file in the spreadsheets folder (I dont know how to do that).
Next time someone opens the spreadsheet it automatically reads the version number in the cell, checks it is the same as the one stored in the text/xml file, and if so lets the user in. If not tells them to update their spreadsheet and quits. (I dont know how to do these either).

Ok I am playing around

I can record a macro that adds 1 to the version number cell. But the save button, where do I find the programming behind that so I can insert my macro into that program?

Hi All

Another possibility I now how to attach a macro to a button. Here`s an unusual question - How do I attach a macro to the save button?

Figured it out everyone

I found out how to run a macro on opening and closing a spreadsheet. So I have a version number on a sheet, exit I increase it by one and export to a text file. Open, I imported from a text file and check it against the version number on the sheet. Turned out to be quite easy in the end.