Version control for MS Office docs

[JohnnyOldBoy]

Does anyone have any experience of applying version control for MS Office documents ?

I get involved in producing documents which evolve over time and as I save them I use 'save as' and use a simple ver01, ver02 etc. At some point I have to share the documents for review and to ensure we are all reviewing the correct document I would like to automatically time stamp the document by including date and time in the filename. For example 'contract for services yyyy:mm:dd hh:mm.doc'. I know you can see date and time in explorer but when emailing and viewing attachments on SmartPhones and Tablets it is easier if the date is included in the filename.

John

 

[Clive]

Which version of Word are you using?

Here is a simple macro for Word 2010

Sub DateTimeSaveAs()
'
' DateTimeSaveAs Macro
'
'
Dim currentDateTime As Date
Dim formattedDateTime As String
Dim documentName As String
currentDateTime = DateTime.Now
formattedDateTime = Format(currentDateTime, "yyyy-mm-dd Hh-Nn")
documentName = InputBox("Please enter the name of your document.", , "Contract for Services " + formattedDateTime + ".doc")
If (documentName <> "") Then
ActiveDocument.SaveAs2 (documentName)
End If
End Sub