This is sort of working. I can see how it is a start in the correct direction. Obviously I had to change to reflect where my source data and text file are, but that's ok.
One thing I don't understand...
In this line:
the resulting array has only one line/element [str(0)]. If I change the 'vbNewLine' to 'vbLf', the array does have each line from the source text [Str(0) through Str(n)].
But it appears to fail the compare. If I leave it as 'vbNewLine', the For-Loop does nothing, since there is only Str(0); which does have the complete text from the cell.
So, I may have asked my question incorrectly. Imagine I have several pages from a book. Each paragraph is copied to one cell (with vbLf for EOL). I get a new text file with corrections that may have adds, changes or deletes for any individual paragraph. Some paragraphs will not change, but some might. So, any paragraph that does not completely match the cell should pop an error. I have other ways of detecting new paragraphs, so that isn't required. But, if a paragraph is gone, I need that to alert as well, just as if a paragraph has a minor edit within.
Perhaps asking a complete question is helpful?