Something like thisOriginally Posted by Aflatoon
[vba]
ThisWorkbook.SaveAs Filename:=ActiveWorkbook.Path & _
Application.PathSeparator & nwb, FileFormat:=xlOpenXMLWorkbookMacroEnabled
strName = ActiveWorkbook.Name[/vba]
Something like thisOriginally Posted by Aflatoon
[vba]
ThisWorkbook.SaveAs Filename:=ActiveWorkbook.Path & _
Application.PathSeparator & nwb, FileFormat:=xlOpenXMLWorkbookMacroEnabled
strName = ActiveWorkbook.Name[/vba]