Skip to main content

Create auto backup for word documents using macro.

This is a macro for Microsoft Word to save documents with incremented revision numbers in order to prevent loss of work and to easily revert changes.

When saving this will save the document with the original filename.
Everytime it is saved using this macro it will append the revision number to the filename.
For Example: Dissertation – Revision 011 – Jan 6 2011.doc

Installation instructions for Microsoft Word 2010:
Make sure the Developer Tab is enabled:
Office 2010:
Click File -> Options
Click Customize Ribbon on the left.
In the right column, check the ‘Developer’ check box.
Click OK.
Office 2007:
Click the Office button in the top left.
Click “Word Options” located in the bottom right of the menu.
On the left, click Popular.
In the right column, click “Show Developer tab in the Ribbon”.
Click OK.
Click the Developer tab in Word.
Click Macros.
In the Macro name field type “SaveMacro” and click the Create button.
Delete everything from Sub SaveMacro() to End Sub.
Copy and paste all the text in the box below:


Sub SaveMacro()
Dim WSHShell, RegKey, rkeyWord, Result
Set WSHShell = CreateObject("WScript.Shell")
Dim intCount As Integer
Dim strDate As String
Dim strPath As String
Dim strFile As String
Dim strFileType As WdDocumentType
Dim strRevisionName As String
Dim intPos As Integer
Dim sExt As String
strDate = Format((Date), "dd mm yyyy")
sExt = ".doc"
strFileType = wdFormatDocument
With ActiveDocument
On Error GoTo CancelledByUser
If Len(.Path) = 0 Then
.Save
End If
strPath = .Path
strFile = .Name
End With
intPos = InStr(strFile, " - ")
If intPos = 0 Then
intPos = InStrRev(strFile, ".doc")
End If
strFile = Left(strFile, intPos - 1)
Start:
RegKey = "HKEY_CURRENT_USER\Software\Microsoft\Office\Word\Settings\"
On Error Resume Next
rkeyWord = WSHShell.RegRead(RegKey & strFile)
If rkeyWord = "" Then
WSHShell.regwrite RegKey & strFile, 0
GoTo Start:
End If
intCount = Val(rkeyWord) + 1
WSHShell.regwrite RegKey & strFile, intCount
strRevisionName = strPath & "\" & strFile & " - Revision " & Format(intCount, "00#") & " - " & strDate & sExt
ActiveDocument.SaveAs strRevisionName
Exit Sub
CancelledByUser:
MsgBox "Cancelled By User", , "Save Cancelled."
End Sub


Sub FileSave()
SaveMacro
End Sub


Now click on the down arrow from the Quick Access Toolbar, then click More Commands…
Now under where it says “Choose commands from:” change the drop down box to Macros.
Click on Normal.NewMacros.SaveMacro then click Add.
It will now appear in the right column.
If you want to change the icon, click on the Macro, then click Modify below.
Once done, click OK.

Comments

Popular posts from this blog

Office 2013 Error "Microsoft Word has stopped working".

Problem: Office 2013 Error "Microsoft Word has stopped working". Cause: This issue could in office 2013. 1.) Abby Fine Reader 2.) Graphic Card Driver. 3) Any Third Party Addin. Solution: Method 1: 1) Look for Abbyy Fine reader in control panel. 2)Remove it from the program list. 3)Restart the computer and check the status. If you are not able to remove it update the latest Update for Abbyy Fine Reader from their website. Method 2: 1) Try to disable Graphic adapter from Device manager Locate Device Manager: Right Click on My computer-->Properties -->Device Manager. 2) Open office application. 3)Check the status. Method 3: 1)Open any office application. 2)Open file-->options--Advance. 3)Disable Hardware Acceleration. Method 4: 1)Open Event Viewer by Run Window(Crtl+R) 2) Type eventvwr.msc and look for the office error. 3) Look for faulting module and rename the file from the file location. 4) Open office application and

Setup cannot find office.en-us\dwtrig20.exe during office installation

Problem:  Setup cannot find office.en-us\dwtrig20.exe during office installation Solution: Method 1 : a) Uninstall skype form control panel. b) After installing office, re-install skype. Method 2: a) Browse disk by right clicking on it with mouse. b) Double click on setup.exe file from the same location. Method 3: Note: Take backup of your registry before modifying it.  For registry backup: open "run" >> type "regedit" >> goto "file" >> click on "export" on desktop. a) Edit the registry. HKEY_LOCAL_MACHINE > SOFTWARE > MICROSOFT > OFFICE Delete the keys (items) you find in the OFFICE folder but not the sub-folders. This removes traces of previous installs to avoid possible conflicts when installing the new version of Office. b)HKEY_LOCAL_MACHINE > SOFTWARE > MICROSOFT > OFFICE > DELIVERY > SOURCEENGINE > DOWNLOADS Delete the keys (items) you find here.

We're sorry, but Excel has run into an error that is preventing it from working correctly. Excel will need to be closed as a result. Would you like us to repair it now?

Issue: We're sorry, but Excel has run into an error that is preventing it from working correctly. Excel will need to be closed as a result. Would you like us to repair it now? This error occur due to some compatibility with the older version office installation. 1.        Go to C:\Program Files (x86)\Microsoft Office\Office15, look for EXCEL.EXE 2.       Right Click on this, Properties, In Compatibility tab, check ""Run this Program as an Administrator" 3.       Start the Excel. You might again get the error. Close Exel and uncheck ""Run this Program as an Administrator"". Start Exel again. You should not get the error anymore. 4.       File > Options > Advanced - In General section (go very much down in Advanced), check ""Ignore Other applications that use Dynamic Data Exchange (DDE)"". Close and re-start the Excel. Uncheck ""Ignore Other applications that use Dynamic Data Exchange (DDE)&q