Vb script to read text file

Echo infoResult. Hi All,. I'm looking for basically the same thing as you have here. I'm trying to get the output into excel as:. Any help would be greatly appreciated. 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. FileSystem object to read the contents of a text file into a string, supplying the path.

The following example reads the contents of test. FileSystem object to read the contents of a text file into a string, supplying the path and file encoding type.

The following example reads the contents of the UTF32 file test. The path is not valid for one of the following reasons: it is a zero-length string, it contains only white space, it contains invalid characters, or it is a device path ArgumentException. The path is not valid because it is Nothing ArgumentNullException. The file does not exist FileNotFoundException. The path exceeds the system-defined maximum length PathTooLongException.

A file or directory name in the path contains a colon : or is in an invalid format NotSupportedException. There is not enough memory to write the string to buffer OutOfMemoryException.

The user lacks necessary permissions to view the path SecurityException. Items WScript. Echo line Next. Improve this answer. Sandra Rossi An anonymous user has suggested some changes to your code. It seems like a valid point, but I don't know for sure. Perhaps you might wish to consider it.

CreateTextFile "in. OpenTextFile "out. ReadAll inFile. Close ' Write file outFile. Zimba Zimba 1, 12 12 silver badges 17 17 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back