Excel XP 2003 changes from Excel 2000
 

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

Excel XP 2003 changes from Excel 2000
 

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

Excel XP 2003 changes from Excel 2000
 

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


.

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


.