ActiveWorkbook.SaveAs FileName:= _ "<path statement and filename>.xls", FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=FalseA quick way to find out what the macro should be is to turn the macro recorder on, perform the operation that you wish to do, stop the recorder and look at the macro in the Object Viewer. The recorder and the viewer are in the Macro tab in the Tools menu.