Importing specific data from a Text file

Hello all

I am looking to import specific data from a text file (only certain lines). I assume using VB code is the way to go, but am not sure what the code should look like (I have done limited VB programming).

I am looking for code that will:
1. When run, will ask me for the path (let me browse) to the file location (but I could hard code path).
2. Will import (read) only certain defined information and append the data to the current data column. The file is like:

Box1_a, 10
Box1_b, 15
Box1_c, 20
Box2_a, 25
Box2_b, 30
Box2_c, 35
Box3_a, 40
Box3_b, 45
Box3_c, 50

And I just want to import the values of lines 1, 4, 7 (10,25,40). These values would be append to the data from the previous import.

Any ideas

Thanks

Charlie

You can import it into a new worksheet and then delete the new worksheet after you copy/paste the specified rows. Something like this:

Please Login or Register  to view this content.

Hope that helps.