Hi all Creating a new workbook from the active sheet is not so easy anymore now we have Excel 2007 with so many different file formats. Below is a code example to copy the active sheet to a new workbook and save it. This example is working in 97/2007. If you run the code in … Continue reading SaveAs in Excel 2007