enjam
08-03-2021, 09:42 PM
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
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