View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tomer Tomer is offline
external usenet poster
 
Posts: 1
Default 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.