>Naomi,
>
>Your problem is the format you are saving the spreadsheet in:
>
>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.
>
>If you use Excel8 format (56) , then conditional formatting is retained.
>
>
>loExcel.ActiveWorkbook.SAVEAS(tcXLSFileName, 56)
>
>
>
>Gary.
Thanks, Gary, this seems to work.
If it's not broken, fix it until it is.
My Blog