| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving text files in excel 95 foremat
I'm using Excel 2000. In a macro I load a txt file of
50,000 lines of information, and save it as an excel 95 foremat. When I re-opne the file it has been reduced to about 17,000 lines. Any ideas why and how to get round it? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving text files in excel 95 foremat
Excel 95 doesn't support 65536 rows, only 16384.
"DAubrey" wrote in message ... I'm using Excel 2000. In a macro I load a txt file of 50,000 lines of information, and save it as an excel 95 foremat. When I re-opne the file it has been reduced to about 17,000 lines. Any ideas why and how to get round it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seeing Text File Names when Saving Excel Files | New Users to Excel | |||
| saving excel files | New Users to Excel | |||
| NOT saving Excel files | Excel Discussion (Misc queries) | |||
| Saving excel files | Excel Discussion (Misc queries) | |||
| Saving spreadsheets as delimited text files | Excel Programming | |||
Hybrid Mode
