I have this code in a module to save the workbook as a new file.
My problem with this is that it closes the new workbook. I want it save the template workbook as a new workbook but keep the new workbook open.![]()
With ActiveWorkbook .SaveAs Filename:=strWorkbookFolder & strUserDesc & ".xls", FileFormat:=xlNormal .Close False End With
I guess it is only a small amendment but I'm not sure what to change/add?
Bookmarks