Getting rid of Word control characters before writing text to another application
Posted on 2004-08-08
I'm developing a script for work using VBA that reads information from a MS Word Document, uses Split to create an array, then writes the contents of the array into an Excel file. The Word document is a highly formatted Form and I need the data to be placed in Excel so that it is delimited by the text in each section (one cell per line of text, basically).
Everything is almost great using Chr(13) as my Split delimiter character, this splits the text correctly but I still get some looking characters outputted to the Excel sheet. I want to suppress these control characters but have so far had no success in doing it. I need the characters to be gone so that I can next use ADODB to create a recordset from the Excel sheet and I only want text in the recordset. I've marched through every ASCII charachter from 0 to 255 with no success. How do I get rid of the remaining control characters before they go into the array or before they go into the Excel sheet?
Here is an example of the output..... PUT IN VERIFIED PUT IN VERIFIED PUT IN VERIFIED PUT IN VERIFIED
BY BY BY BY BY BY BY BY