how to import specific row from a txt file into excel using macro ?

[kumar77]

Buddies, I am looking for some macro help in importing some selective data from txt file to excel. There are around 1 lakh rows in the text file. I want to import only selective 1000 rows. Below are the sample rows in the text file.

012012031000050040280000050643000079000079000039000079
012012031000050050000000050643000089000039000039000099
012012031000050045550000050643000019000039000069000049
012012031000050045270000050643000088000031900033000019

1. I want to select only the rows which has the value "4028" starts at position 17 and ends at 20 for import.

2. While importing the data in the each row should be splitted with fixed width of 6.
eg. 012012 031000 050040 280000 050643 000079 000079 000039 000079

[Sean Thomas]

i think you will need to import the whole text file first
then
find the rows with your required value.
delete other rows.
then split the data.

heres a link with dome code to import your text file

http://excelexperts.com/VBA-Tips-Import-A-Text-File

[millz]

Try this macro, I did not test it though:

Edit: forgot to mention, run it on a blank worksheet.

Please Login or Register  to view this content.

[hudibyk]

I'm not sure, bur probbably it's possoible to import specify rows. Browse through this link
http://newtonexcelbach.wordpress.com...m-a-text-file/

[Sean Thomas]

Hi
this should work
run the sub Test
select your text file
it will import the data
remove any rows without 4028
then split the data into columns

[kumar77]

Awesome Millz. . It works perfectly as i expected . .Thanks a lot