This is one area where I have always had issues... I want to save a copy of a sheet using this code:
Sheets("Air").Copy Sheets("Air").SaveAs Filename:="N:\National Share Drive\1 CSU Homepage\CS Interactive Reports\Formatted Reports\" & strClientName & "-Air-" & Format(Date, "dd.mm.yy") & ".xls", FileFormat:=xlXMLSpreadsheet Workbooks(strClientName & "-Air-" & Format(Date, "dd.mm.yy") & ".xls").Close
This works, it saves only the "Air" sheet as a new workbook, but when ever anyone opens the new file it comes up with the "the fileformat does not match the extension blah blah blah"
I'm after just a standard .xls file, so that none of my code is saved with the report, can someone in the know about this direct me as to how to save just the standard no macros .xls workbook??