Impoting a text file - Excel 2000 VS. 2003
Hi
I have a very wierd problem I imported a file with the OpenText command using just the file name It worked perfectly in Excel 2000 and it also works in Excel 2003 The problem is that in Excel 2003 many empty lines in the text file have been erased and where not imported into the excel When i do the same in a computer that has Excel 2000 the empty lines where imported successfull into the excel I tried to find out what is the difference between them and i think it is related to the File Origin propert of the OpenText command but i am not sure When i right click on the file from the windows explorer (i have windows 2000) and open the text fil with the Excel 2003 then the excel opens the file correctly with the empty lines Can you help me ? Thanks. |
All times are GMT +1. The time now is 10:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com