Paul you legend, code works brilliantly. only problem is it places all info
in the first cell but that's easily sorted with a quick "text to column".

Nice one mate, thanks

"Paul B" wrote:

mike, have a look here,

http://redirx.com/?334z


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"mike_vr" wrote in message
...

Right, so this one is a biggy for me, and I'm stumped.

Basically, I have to analyse the mobile phone records for my company. The
invoice comes in on a disk, and now it's my job to go through all the
calls
picking out certain numbers, users, etc.
Anyway, after exporting the data to a .txt file, i now need to open it in
excel so I can start comparing and so on. Unfortunately, this is a big
company and turns out, there are a lot of calls being made.
So excel is unable to open anything more than the first 65 000 odd rows of
calls. I still need a lot, lot more.
Is there any way that Excel can carry on opening the txt file in another
worksheet or something like that.
For instance, as soon as one worksheet is full, move on to Sheet 2 instead
of just stopping the opening?

If anybody has any ideas they would be greatly appreciated, 'cos there's
no
way I'm going through those records manually.

Thanks a lot,
mike