Import Text File Into A Spreadsheet with over 65,000 lines

  • Thread starter Thread starter Ecohouse
  • Start date Start date
E

Ecohouse

I need to have some VBA code to import a text file into an excel
spreadsheet. I know that a worksheet can't have more than 65,000
lines. So the overflow needs to go into another worksheet. And the
text file uses the ";" as the delimiter.

Any help would be appreciated.
 
Back
Top