Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2000 versus 2003 and the TEXT Function Art H Excel Worksheet Functions 2 November 10th 06 08:43 PM
How to emailing file from Excel 2000 to 2003, cannot open?? bennyw0528 Excel Discussion (Misc queries) 2 November 1st 05 10:37 PM
Problems using Excel 2000 to open/save file saved in Excel 2003 [email protected] Excel Discussion (Misc queries) 1 June 29th 05 02:50 AM
Excel 2003 File Closes In 2000 [email protected] Links and Linking in Excel 0 March 5th 05 05:20 PM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM


All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"