Convert a text file to a unique list of words.

[111StepsAhead]

Hello,

I am trying to create an excel program that will let the user select a text file and automatically convert the file into a list of unique words in excel. My biggest issue is reading one word at a time. Does anyone know how I might do this?

Thank you,

[millz]

you can try using Split function. read a line of text from the text file and use something like this

Please Login or Register  to view this content.

[ragulduy]

Maybe something like:

Please Login or Register  to view this content.

[111StepsAhead]

yudlugar,

Your code threw a bug at

Please Login or Register  to view this content.

which I got to work by changing that If statement to

Please Login or Register  to view this content.

So from here it should be easy to work with. Thank you very much and have a good day. I am going to mark this thread as solved now.