I have a VBA macro which runs from Excel, opens a Word document and reads cells in a table in the Word document.
I read the cell with the code:
<code>
TrStr = .cell(3, 4).Range.Text
</code>
I need to know if the cell is empty. Sometimes the cell contains a Text Form Field which is empty, but because the Form Field itself is considered something (usually 5 blank spaces), it doesn't detect that it is empty.
How do I detect first that there is a Text Form Field in that cell, and second that the field is empty?
Thanks,
Jeff
I read the cell with the code:
<code>
TrStr = .cell(3, 4).Range.Text
</code>
I need to know if the cell is empty. Sometimes the cell contains a Text Form Field which is empty, but because the Form Field itself is considered something (usually 5 blank spaces), it doesn't detect that it is empty.
How do I detect first that there is a Text Form Field in that cell, and second that the field is empty?
Thanks,
Jeff