Excel 2010 Version Control

[RyanPitt]

Dear all Mr Excel Gurus,

I am attempting to build a workbook, which will be continually updated. However, I would like to be able to keep each and every version of the workbook that is saved.

I can obviously set a macro to encourage everyone to Save As, rather than just save over the top, but this could be saved as anything and might not follow my "rules" of version control...?

Ideally, i would like some kind of module or macro that would save the document in a certain format. ie.

Important Workbook V0.1
Important Workbook V0.2... etc

Also, if this is possible, then would also like excel to notify someone if they are not in the most uptodate version of the document, although i feel this might be stretching the excel technology slightly.

Any help or guidance you can give would be greatfully received.

Cheers

Ryan

 

[GTO]

I am attempting to build a workbook, which will be continually updated. However, I would like to be able to keep each and every version of the workbook that is saved.

I can obviously set a macro to encourage everyone to Save As, rather than just save over the top, but this could be saved as anything and might not follow my "rules" of version control...?

ThisWorkbook.SaveCopyAs FullName

...along with some checking as to what versions (filenames) exist in a predetermined folder might work. I would think we'd be saving an awful amount of data in a short time; presuming users have the good habit to save often.

Ideally, i would like some kind of module or macro that would save the document in a certain format. ie.

Important Workbook V0.1
Important Workbook V0.2... etc

Not testing at the moment, but I think SaveCopyAs keeps the same fileformat. If you are referring to naming the workbook, I would tack on numbers at the end as you show, but not wanting a headache, I would stack zeros at the start to make the string easy to compare.

Also, if this is possible, then would also like excel to notify someone if they are not in the most uptodate version of the document, although i feel this might be stretching the excel technology slightly.

Sort of not applicable if you save the copies to a tucked-away folder. IMO, having a bunch of different versions in the same folder (all easily spotted by the users) begs for less satisfactory results.

Hope that helps,

Mark

 

[Kyle123]

Do you have sharepoint?