Hey, Some time back somebody wanted a code for creating a backup of their files while working on them. Given is a code for saving a file in excel. You may create the macro in the workbook. ________________
Private Sub Workbook_BeforeSave(ByVal _ SaveAsUI As Boolean, Cancel As Boolean) With ThisWorkbook .SaveCopyAs ("c:\Backups\Backup of " & .Name) End With End Sub ______________ Hope you find it useful. I have yet to get the macro for MS word. regards VS To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in