Exporting from Word Textboxes to Excel

[enjam]

Hi all,

I've got a collection of 50 word documents with specific data stored in textboxes.

I'm trying to build a macro that will loop through each file (named 50000.docx, 50001.docx etc. to 50050.docx), and if:

1) the file is able to be opened, and
2) .Shapes(4).TextFrame.TextRange.Text and .Shapes(36).TextFrame.TextRange.Text and .Shapes(37).TextFrame.TextRange.Text have content, even if that content is blank

Then I'd like to populate an Excel spreadsheet with column A containing the content found in .Shapes(4) in each document, column B containing the content found in .Shapes(36) in each document, and column C containing the content fond in .Shapes(37) in each document.

I hope the attachments can help clarify what I am after.

Collection of files:

28813

Input (Word Document):

28814

Output (Excel):

28815

Any help would be greatly appreciated.

Thank you,
enjam