![]() |
|
#1
|
||||
|
||||
![]()
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] |
#2
|
|||
|
|||
![]() Quote:
1. If I open Word (no document opened, just blank page), modify it and choose to close Word, a SaveAs dialog is shown. Is there a chance to show an ordinary Word dialogue asking a question whether a document should be saved or not ot, or to cancel? Currently, in the above-mentioned situation, there is no chance of quitting Word without saving, that is, when I choose not to save, I get back to Word (it does not exit.) I have also one comment. If a document exists on, say, harddrive, pendrive etc. and I modify it and choose to save, there is a dialogue box asking whether to save or not. In this situation, saving without asking would be preferred for me. I have changed the macro accordingly. Please see it below. Code:
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 .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 I have also changed your first macro to exit Word when I choose to do so and if a document is empty. Code:
Private Sub Document_Close() Dim blank As Range For Each blank In ActiveDocument.StoryRanges If Len(blank.Text) = 0 Then Exit Sub Next Call FileSave SendKeys "{ESC}" End Sub |
#3
|
||||
|
||||
![]() Quote:
If Len(Trim(.Range.Text)) = 1 Then Exit Sub after: If .Path = "" Then: If Application.Dialogs(wdDialogFileSaveAs).Show <> -1 Then Exit Sub in the code I posted. Having code that results in the dialogue box opening for every save is the only way I could find to ensure a backup gets created.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
![]()
Thanks for you help! I will try to look for a workaround for this.
|
![]() |
|
![]() |
||||
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 |