Application.Displayalerts = False
Thisworkbook.SaveCopyAs _
filename:="C:\MyBackups\ & thisworkbook.Name
Application.displaAlerts = True

--
Regards,
Tom Ogilvy


"Tony Callender" <Tony wrote in message
...
Hi

Would you like to share your backup macro, perchance? Can it backup to
another hard drive than the one that the original file is saved on?

Thanks
Tony

"Bob" wrote:

I have a macro which creates a backup of my workbook.

I now need a macro which will display a message if that
backup macro has not been run within say the last 7 days.
Can this be done with VBA?

Thanks