Workbook.SaveCopyAs (Excel)

Saves a copy of the workbook to a file but doesn't modify the open workbook in memory.

SaveCopyAs (Filename)

Filename: Specifies the file name for the copy.

ActiveWorkbook.SaveCopyAs "C:\TEMP\XXXX.XLS"