Import Text File Into A Spreadsheet with over 65,000 lines
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. |
Import Text File Into A Spreadsheet with over 65,000 lines
http://support.microsoft.com/kb/120596/en-us
Importing text files larger than 65536 rows That should be a start. -- Regards, Tom Ogilvy "Ecohouse" wrote in message oups.com... 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. |
All times are GMT +1. The time now is 09:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com