View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_3_] Robert Crandal[_3_] is offline
external usenet poster
 
Posts: 161
Default Iterate through all words

I have a text file that is read and stored into a string variable.
Here is the basic code:

Dim s as String

s = ReadTextFile("C:\data.txt")

I would now like to retrieve each and every word that is
stored in the variable "s". Loading all the words into an
array will be okay for now.

For my purposes, a word is any string of characters that
does not include whitespace characters, such as spaces,
tabs, carriage returns, line feeds, etc... I think those are
the only whitespace characters that exist, right?

Gary, do you recommend that I use the Split() function for this?