This is memory-dependant! In this case it's better to import the file
in 'blocks' first, then output to the worksheet block by block.
This gets more involved and so is why I diverted to working directly
with worksheet ranges because the row limit is as per Excel version! I
was going to limit the output array to each loop step but didn't see
much advantage since it's only 10 rows of data. Otherwise, if you'd
like an example just post back a request...
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion