![]() |
#2
|
||||
|
||||
![]()
You might want to take a look at: http://www.gmayor.com/automatically_backup.htm
If nothing there suits your needs, you might try something along the lines of: Code:
Private Sub Document_Close() Call FileSave SendKeys "{ESC}" End Sub Sub FileSave() Dim BackupPath As String, objF As Object, retVal As Long, Rslt BackupPath = "C:\Users\" & Environ("UserName") & "\Documents\BackupWord\" With ActiveDocument If .Path = "" Then: If Application.Dialogs(wdDialogFileSaveAs).Show <> -1 Then Exit Sub If .Saved = False Then Rslt = MsgBox("Do you want to Save Changes?", vbYesNoCancel, "File Save") If Rslt = vbNo Then .Saved = True Exit Sub ElseIf Rslt = vbCancel Then Exit Sub End If End If .Save If Dir(BackupPath, vbDirectory) = "" Then MkDir BackupPath MsgBox "Backup folder has been created.", vbInformation End If If .Path & "\" = BackupPath Then MsgBox "WARNING! Backup folder is the same as the source folder", vbExclamation Exit Sub End If Set objF = CreateObject("Scripting.FileSystemObject") retVal = -1 On Error Resume Next retVal = objF.CopyFile(.FullName, BackupPath & .Name, True) On Error GoTo 0 Set objF = Nothing If retVal <> 0 Then MsgBox "Backup has not been copied to folder " & BackupPath, vbExclamation End With End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
in 2013, cannot format 4 dec places in Word Document | Abacus1234 | Mail Merge | 3 | 10-23-2013 03:57 PM |
Word Documents appear in two places | Drjh68 | Word | 1 | 08-25-2013 03:19 PM |
Forced extra decimal places | Metamag | Excel | 11 | 08-18-2012 03:10 AM |
![]() |
Vampy99 | Mail Merge | 7 | 09-25-2011 05:41 AM |
My Places | lukewarmbeer | Office | 0 | 07-13-2010 02:33 PM |