Reply to thread

Message: [QUOTE="MCC Wong, post: 3434110"] Thanks Dibben, I've tried the VBA code, but not successful. Since I'm not familiar with using VBA code or writing macro, can you teach me how to do it?? I have created a shared electronic bank book namely 'HSBC.xls' in J drive and when I save this file, I would like to make a backup copy in C drive namely 'Backup HSBC', but I don't know exactly how to write VBA code. Should I use the macro function or the Visual Basic Editor under Tools?? Please teach me how to write the macro or VBA code!! I've tried the following as suggested but won't work: Sub HSBC (ByValSaveASUI As Boolean, Cancel As Boolean) Application.DisplayAlerts = False ActiveWorkbook.SaveCopyAs "C:\Backup HSBC.xls" & ActiveWorkbook.Name ActiveWorkbook.Save Application.DisplayAlerts = True End Sub What have I done wrong?? please advice!! MCC [/QUOTE]