-
Exporting from Word Textboxes to Excel
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:
File Collection.jpg
Input (Word Document):
Input (Word File).jpg
Output (Excel):
Output (Excel).jpg
Any help would be greatly appreciated.
Thank you,
enjam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules