| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I import text file of cash flow to excel file then use formula | Excel Discussion (Misc queries) | |||
| Import csv file - blank lines inserted | Excel Discussion (Misc queries) | |||
| How do I import text file, analyze data, export results, open next file | Excel Programming | |||
| excel97 vba to append lines to text file overwriting last 2 lines | Excel Programming | |||
| Import selected lines from an Ascii file | Excel Programming | |||
Linear Mode
