View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Matlack[_67_] Brian Matlack[_67_] is offline
external usenet poster
 
Posts: 1
Default Importing large file


Hi!
I sometimes need to import a data file that is over
one-hundred-thousand lines long. Usually I break-up the report into
several smaller reports and then consolidate them into several sheets
of an excel workbook.
Is there a way to do this in VBA that could do the entire file (100,000
lines or more) at once?

Any help or suggestions would be greatly appriciated! THANKS!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=536126