Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Strange 'protected cell' error affecting Excel 2003 but not Excel 2000? | Excel Discussion (Misc queries) | |||
Opening files in Excel 2003 saved in Excel 2000 without data loss... | Excel Discussion (Misc queries) | |||
Excel 2000 and Excel 2003 in Office 2003 | New Users to Excel | |||
Upgrade from Excel 2000 to Excel 2003 without MS Office 2003? | Excel Discussion (Misc queries) | |||
Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) |