Quote Originally Posted by DaveM View Post
Paul, nice use of the character class ([^13^l]) in the .Find function to replace all LineFeeds and FormFeeds with a paragraph mark (pilcrow -
¶).... which you later replace in the Excel range with a Carriage Return (char(10)). Do LineFeeds and FormFeeds both mark the end of a table?
This process concerns Word table cells that contain paragraph breaks and/or line breaks. If those are not removed before copying the table to Excel, the output goes to separate rows in Excel. The subsequent replacement of the pilcrow in Excel is to restore those formats as line breaks within the cells concerned.

Word table cell and row ends are designated by the Chr(13) and Chr(7) pair, which appear as '¤'symbols.
Quote Originally Posted by DaveM View Post
I do have a question about your use of the BinaryCompare argument to the Split() function. Why not the TextCompare argument?
Since Word files are ordinarily saved with lower-case extensions (.doc, .docx, .docm), I saw no need to add the the TextCompare argument.