I need help with VBScript. I have a text file that is attached. I need a VBScript that can parse the text file and read the rows and update the data in the excel file.
Each record in the text file comprises of 2 rows, so both rows must be read to update one row in the excel file.
The data that needs to be read in the text file is
1. 'Person name' that starts from Position 151-175 in the text file (line 1)
2. 'Code' that starts from Position 18-52 in the text file (line 1)
3. 'Object' that starts from Position 162-166 (line 2)
4. 'Default #' that starts from Position 151-160 (line 2)
Opening this sample file in a good editor will give you the position #. I used Notepad++.
Thanks in advance for your help.