Importing Text File with more than 65536 rows

A

Allan

I am tring to import text files, into column A, but some files contain more
than 65536 rows. I would love to get the rest of the file in Column B if when
the file contains more than 65536 rows
 
A

Alok

Look at this link. Microsoft article explains how this can be done. You may
have to modify the code somewhat since you want the additional data to go
into column B rather than to the next sheet.

Alok Joshi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top