File SaveAs

[crmulle]

I perform a file save as in the workbook but when I do this I the original
file is no longer open. This causes me to manully reopen the original file.
I would like the original file to remain open even during or after the new
workbook is created.

Any ideas....thank you.

My current code is below:

ActiveWorkbook.SaveAs Filename:="WHLS Oversight Rpt " & Format(Date,
"mmddyy") & ".xls", FileFormat:=xlExcel8, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False

Application.DisplayAlerts = True

Application.ScreenUpdating = True

ActiveWorkbook.Close

End Sub

 

[crmulle]

Steve,

I need to save the file with the new changes under a new name but also keep
the old file open...does that make sense?