Capture content controls to Excel, handle various control types

[gmaxey]

You can start by removing "Trim" after .Text. That is what caused the invalid qualifier. Do you want to "Trim" the content of the CC?

Trim(WordDoc.ContentControls(i).Range.Text)

Change the second "True" to "False" as Graham correctly points out.