strFile = replace(strOrigFile,".csv",".xls")
Set objExcel = CreateObject("Excel.Application")
objExcel.Workbooks.Open strOrigFile
objExcel.DisplayAlerts = False
objExcel.ActiveWorkbook.SaveAs strFile, -4143
objExcel.DisplayAlerts = False
objExcel.ActiveWorkbook.Close
objExcel.DisplayAlerts = False
objExcel.Application.Quit
This code is not working when converting csv to xls, Please help !