View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ej_user ej_user is offline
external usenet poster
 
Posts: 3
Default Reads entire *.txt file into string opposed to a desired line by line input.

I have a text file of html source code (acquired using openurl) that I
want to read into Excel through VBA. My problem in the entire file is
read into a string; I want to evaulate the file line by line.

The text file contains a character that resembles a rectangle standing
on end that is understood in Wordpad as a carraige return - i think.
If I open the source code text file in Wordpad and save it as a DOS
text file, I can read the file just fine in Excel using VBA. How can
I programmatically resolve this issue?

thx.
Edward