View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Robert[_34_] Robert[_34_] is offline
external usenet poster
 
Posts: 6
Default Importing from a text file

I actually don't want a delimiter -- the code I use is expecting all
the content to be in Column A. I just want all the individual lines
from the text file put on a single row in Column A. Will the
ImportTextFile program work without delimiters? And I'm not sure what
kind of carriage return is at the end of each line. Do you know of a
way to find the ascii value and convert it to a vbNewLine character?