Excel XP 2003 changes from Excel 2000

  • Thread starter Thread starter Michael Gamer
  • Start date Start date
M

Michael Gamer

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
 
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?
 
The consecutive delimiters option is not relevant here as
the line feed is not the delimiter!

Michael
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA help: Text file formatting 19
Sort problem in Excel 2007 3
Can't Open Text File From Website in Excel 2010 0
Excel Change Text to Date 3
Worksheet copying in Excel 2007 3
Workbooks.OpenText Error 1004 3
Create if partial match then copy and paste data from one cell to another 1
Porting from Excel 2003 to Excel 2010 12

Back
Top