when I ran the following codes inside MS EXCEL, it worked fine. but, it does not work when I ran in a VB script from WINDOW. I am planning to schedule running this script nightly to convert 20 input *.csv files to Excel files with beautiful fonts and colors.
oBook.SaveAs "C:Book1.xls"...
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...