OK, first of all, I've searched all over this forum and google and can not find an answer. I am not a vb developer, but searching (desperately at this point) for a way to convert an xls file to a tab delimited txt file via the command line.
I found this one that saves as a csv (comma delimited) but can't figure out how to change it to save as tab. I can't believe that it wouldnt be possible. Please HELP!!
Code:if WScript.Arguments.Count < 2 Then WScript.Echo "Error! Please specify the source path and the destination. Usage: XlsToCsv SourcePath.xls Destination.csv" Wscript.Quit End If Dim oExcel Set oExcel = CreateObject("Excel.Application") Dim oBook Set oBook = oExcel.Workbooks.Open(Wscript.Arguments.Item(0)) oBook.SaveAs WScript.Arguments.Item(1), 6 oBook.Close False oExcel.Quit WScript.Echo "Done"





Reply With Quote