I use the code below to convert CSV files into XLS files, I call this using a batch file.
I have two problems,
1) One of my columns contains 13 digit numbers and in Excel these display like "4.71084E+12" and not "4710836936966" - because the cell format is General. I would like to be able to specify the cell format is text
2) I need to explicitly pass the name of the input and output files in this VB script, I would like to be able to pass these as parameters when I call the VB in my batch file.
Any help greatly appreciated,
ps. I found this which may give some insight towards issuue 1 - http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_22650457.html?sfQueryTermInfo=1+csv+format+xl
oEx.ActiveWorkbook.SaveAs "C:\testing\out.xls", -4143, , , False, False