I have an existing program that runs in my xls and make changes to various
worksheet in the xls, after all the changes, I want the code to save the xls
under another name WITHOUT making saving the changes in the existing xls.
Below is the code that I currently using, while saving the file as a new xls
this code also make save changes to my exisiting xls, could anyone tell me
how I can alter the code so that it does not save the changes in the existing
xls?


Application.ScreenUpdating = True

ChDir "S:\Prof\Monthly\2007"
ActiveWorkbook.SaveAs Filename:= _
"S:\Prof\Monthly\2007\Report.xls", FileFormat _
:=xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:= _
False, CreateBackup:=False

End Sub

Thx