Save as new file ONLY and do not save changes to existing xls

S

Sin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simplify save code 11
Hiding an Excel file using VBA 1
SaveAs to existing file 5
Original read only file not closing 0
'Save as' dialog opens despite Application.DisplayAlerts = False 6
File Save Question 6
How To Exit Macro Without Debug Prompting 4
File SaveAs 4

Top