Anirban
04-15-2016, 07:14 AM
URGENT HELP REQUIRED
... I am VBA noob
My requirement is simple. I need to open the attached FILE.TXT file by the button click and read through each line of file.
Whenever I find the word "polisnummer", I write value of the policy in cell A6 & then the value of "attribuut" in cell B6, the the value of "waarde" in cell C6 & the the value of " foutmelding " in cell D6.
Once the next " polisnummer " string is found, I fill similarly in cell A7,B7,C7,D7....and so on (as evident from the excel)
15928
Sample file in the File.ZIP
... I am VBA noob
My requirement is simple. I need to open the attached FILE.TXT file by the button click and read through each line of file.
Whenever I find the word "polisnummer", I write value of the policy in cell A6 & then the value of "attribuut" in cell B6, the the value of "waarde" in cell C6 & the the value of " foutmelding " in cell D6.
Once the next " polisnummer " string is found, I fill similarly in cell A7,B7,C7,D7....and so on (as evident from the excel)
15928
Sample file in the File.ZIP