lookin,
If the file is structured and you have way to identify the required rows,
just query the text file, something like:
SELECT * FROM MyTextFile WHERE ID=161237 AND ID<=161267.
(or is "LIMIT 161236 ,30" supported ?)
Record a new macro whilst making the query will give you the code to play
with. Even set the limits as parameters so you can decide yourself what you
want to import.

NickHK

"lookin" wrote in message
oups.com...
Any other ideas on how to do this using Excel VBA?