Copying certain text in textfile and paste into excel

[djmal]

Hello Guys...I need help here

I have a textfile and i'm using vba for excel to read the textline and paste in into excel..
I have a textfile that contain a thousand of data
the purpose of this project is to copy the textline from the starting text that i choose until it reach the end that i also choose..

here, i have attached a sample textfile that i need to copy to the excel...

fyi, A73, Z1 and A74 F+ is the node number..
For example i want to read A73 until node Z1 only, and my first node is A73, and the last node is Z1
I want it to read the all the textline until it reach the GRT1P1+U8+W8 line of Z1...
My problem is how do i do that...

FYI also, i have thousands of node number..This is just a sample..

Regards...

[mohan.r1980]

hi friend,
why don't you open this text file in excel?
if you open it in excel then you can easily make a loop.

[Leith Ross]

Hello djmal,

This macro will parse the data from the starting node to the ending node and copy it to the ActiveSheet starting in cell "A1". Be sure to change the variables StartNode, EndNode, and the FileSpec to what you need.

Macro Code

Please Login or Register  to view this content.

[/code]

[djmal]

thanks a lot Leith Ross
it works great!!