loExcel.ActiveWorkbook.SAVEAS(tcXLSFileName, 39)
39 = Excel5, I don't know if Excel5 supported conditional formatting but Excel 2007 clearly thinks is does not as if you check the file before this line then your conditional formatting is there. Imemdiately afterwards there is no conditional formatting anywhere in the workbook.loExcel.ActiveWorkbook.SAVEAS(tcXLSFileName, 56)
Gary.