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 [email protected] 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
