View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Haarish Haarish is offline
external usenet poster
 
Posts: 6
Default Import File Line by Line

Hi All,

I have written a function that will open a delimited file, read it
line by line and copy it into different rows under column A of a
sheet. Once it is done, I then compute the last row of data in the
sheet and then to a 'Text to Columns' from A1 to A LastRow.

But the file I import could have fields that are Unicode. So I have a
file that has a text like 'č'. The ASCII value for it is 269. The
macro replaces this 'č' character with a new line. I think that is
because after 255, the count starts from 0 again and since Chr(13) is
the character for carriage return it adds the text to a new line. Do
you have any idea as to how to stop the function from doing this. I do
not want to read the file character by character since the contents
could be really large.

Thanks in advance,
Haarish.