Q:

VBA Excel Backup: Save copy of current workbook via VBA under a new name, keep VBA scripts, no prompt

I need to make a VBA script that can take a complete copy of the current workbook and save it under a new name.
It need to be a complete copy with VBA scripts and everything.
The user may NOT be prompted for anything - the new file name (and location) will be provided by the code.

A:

Surely something like this is sufficient?
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:="C:\Data.xlsm"
Application.DisplayAlerts = True

