I use a VB script to format a MS EXCEL file and then save a copy of it to *.xls. The following command give us a messy look Excel file. while I use "SAVE AS to *.xls" manually, it works fine. Please give me some tips.
objExcel.ActiveWorkbook.SaveCopyAs("D:BANNER_FINANCEGRANT...