Excel is just over 65,000 lines, rows. Should work if it is less tham that.

--
David


"Adrian Q via OfficeKB.com" wrote:


Hi ...
I need to use excel to open a certain text file that is over 65k lines....
How can i use macros to directly generate to a 2nd and 3rd spread sheet and
so on ...using macros?
can anybody give a little bit of help ?

Thanks guys
Cheers
Adrian