Import Txt file over several excel sheets

Tamara · Dec 2, 2008

Hi, I have sucessfully used Ron de Bruin's, Copy Txt to new worksheet macro.
My txt file now however has more lines than what 1 excel page can handle.
Is it possible have the macro identify the last line imported into excel and
place all remaining lines onto a new page?

Gord Dibben · Dec 2, 2008

Tamara

The MS Knowledge Base has code to copy large text files across multiple
sheets.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q120596

Gord Dibben MS Excel MVP

Chip Pearson · Dec 2, 2008

I have code on my web site that will import a text file with any
number of lines and will continue the import process from one
worksheet to the next until the entire file is read in. There is no
limitation on the size of the text file other than the limitation on
Long type variables (4 billion lines) and Excel's own available
memory. There are many configuration options to control how the file
is imported, number of record per sheet, and so on. See
www.cpearson.com/Excel/ImportBigFiles.aspx for code and details.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)