Dim NewWorkBook As Workbook
Application.Workbooks.Add
Set NewWorkBook = ActiveWorkbook
patl said:well, I would like to change the name of the new activeworkbook that was created as well. (from "sheet2" to something else). Is that possible?
ActiveSheet.Name = "Whatever"