This is infuriating and frustrating. No search anywhere can return useful information. So now I bring the full code here hoping to get an answer

I have an excel macro that finds specific data in the spreadsheet, and if it matches various criteria, it should write it out to a word document - a report if you will.

I have everything working in Excel. I also am able to open the document, access it, and even verify that I am getting data from the table cell in word, but for some reason I can not write to it. This is where my delima is. The code is:

Please Login or Register  to view this content.
When I run the above code, the document is opened, if I uncomment the test block and enter text in the cell, it returns it, but if I comment everything out and try to use the TypeText method, it doesn't throw an error, it just ends with no text in the cell. I don't see it going anywhere else either. Anyone see what might be wrong?