File SaveAs

  • Thread starter Thread starter crmulle
  • Start date Start date
C

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
 
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?
 
Back
Top