Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Excel XP 2003 changes from Excel 2000

While the linefeed may not be a field delimiter, it certainly is a record
delimiter - not to say it has any bearing on the problem - as I said, just
something to look at. But its obvious you are know more about this than I
do, so excuse my intrusion.


--
Regards,
Tom Ogilvy


"Michael Gamer" wrote in message
...
The consecutive delimiters option is not relevant here as
the line feed is not the delimiter!

Michael


-----Original Message-----
Just a thought, (I can't test it since I don't have xl

2003 installed here).
Do you have the option to ignore consecurtive delimiters

set?

--
Regards,
Tom Ogilvy


"Michael Gamer"

wrote in message
...
I'm reading in delimited text files using the
Workbooks.OpenText method. Many of these files contain

2
consecutive Line Feeds which on Excel 2000 produce a
blank row.

Excel 2003 however ignores these and does not produce

the
blank rows, which in turn causes HUGE problems.

Can anyone suggest a workaround or explain this a bit
further.

Please reply to the group only.

Michael



.



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
Strange 'protected cell' error affecting Excel 2003 but not Excel 2000? Pheasant Plucker® Excel Discussion (Misc queries) 1 April 10th 07 01:04 PM
Opening files in Excel 2003 saved in Excel 2000 without data loss... [email protected] Excel Discussion (Misc queries) 0 January 29th 07 07:19 PM
Excel 2000 and Excel 2003 in Office 2003 Emon New Users to Excel 0 December 21st 06 09:11 AM
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? brigida3 Excel Discussion (Misc queries) 1 January 22nd 06 05:13 PM
Excel 2003 crashes loading excel files created Excel 2000 Jeff Lewin Australia Excel Discussion (Misc queries) 0 June 27th 05 04:20 AM


All times are GMT +1. The time now is 03:49 PM.

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

About Us

"It's about Microsoft Excel"