Saving, backups, VB

Hi Shani

If you wish to save a copy of the workbook you are working on do the following:

Sub SaveBkUp()

Dim BkUpFileName As String

BkUpFileName = BkUpFileName = "C:\My Documents\BackUps\......"

'Either have the name and path of the backup hadcoded into the code (as Above) or use a input box to enter it

If BkUpFileName = "" Then Exit Sub

ThisWorkbook.SaveAs BkUpFileName

End Sub

Hope this helps

Carlos