convert txt file to xml or txt file to vbs using vbscript
Thanks for your help in Advance,
i need to convert txt file to xml or txt file to vbs using vbscript.
No need to change data in the file need to save as with different format.
You can rename a txt file to a csv file, but you want everything lined up in separate columns you will have to open the text file using FSO, open an Excel file using an Excel COM object. Read the input file using ReadLine, format it and write it out to the Excel row using the relevant columns.
Search the forum for FSO and Excel COM.