the excel file is written during the script properly, the cells are auto fit, the colors are painted. but some how it doesn't save those changes.
till this line objExcelApp.ActiveWorkbook.Save the sheet is colored and cells are auto fit but when it executed this line the changes are gone.
i must mention that i'm creating an xls file (office 2003) and my office version is 2007
Did what you said but still the color and the autofit didnt save.if i'm openning the xls before the save command executed the color and the autofit are there but after the save executed and i try to open the file it display a message "the file you are trying to open "file_name" is in a different format....
what can be the problem?
when i did that in the past using office 2003 the file saved properly.