Read a text file vbscript

Parsing a text file can be risky. In this case, I'm not familiar with nvspbind and the documentation I found does not explain the output. In any case, the example VBScript program below should get you started. All I can say is that the above worked for me using the example file posted above.

I left the "server node" column blank because I don't know what value to use. Hopefully this gives you enough clues to get started. Application" objExcel. Add objExcel. Cells 1, 1. Cells 1, 2. Cells 1, 3.

Cells 1, 4. Cells 1, 5. Cells 1, 6. Cells 1, 7. Cells 1, 8. Cells 1, 9. Cells 1, OpenTextFile objChild. Cells intRow, 2. Cells intRow, 3. Cells intRow, 4. Cells intRow, 5. Cells intRow, 6. Cells intRow, 7. Cells intRow, 8. Collectives on Stack Overflow. Learn more. How to read from a text file using VBScript? Ask Question. Asked 12 years, 8 months ago. Active 1 year, 2 months ago. Viewed k times. I am looking to see a simple way to read from and write to a text file using VBScript.

I think this is an acceptable method for writing to a file. WriteLine "Data to Add to file. Close However, I would like to know how to read from a file in a similar fashion. Cheeso k 96 96 gold badges silver badges bronze badges. Curtis Inderwiesche Curtis Inderwiesche 4, 18 18 gold badges 57 57 silver badges 81 81 bronze badges.

I don't understand. Isn't that what you just did, except you're not using the read methods? Yes, but that will only work for one line. So use the ReadAll method instead — Tmdean. WriteLine writes one line. ReadLine reads one line. Everything read from a text file using VBScript comes in as a string data type. If you want something that you have read to be an integer or a floating point number, then you need to convert the string to that data type. For example, if you have a text file:. If you use VBScript to read this file, all three lines are read in as strings.

For example:. NOTE : the above example does have the limitation that you have to know what kind of data is on each line. This way, when you read a line from VBScript, you will know what kind of data you have.