Hi all,
I'm trying to make an adaptation to the code on this forum here to work to my specific case.
https://www.excelguru.ca/forums/show...-Word-to-Excel
In post 4 Macropod's VBA script uses a folder as the source and goes through multiple word docs to pull data into one workbook.
However I only need a limited amount of data from the word document and I would like it to be added to a single worksheet.
I'd Like to have a header and then have the macro put the data into the rows beneath each header.
A new row for each word document it extracts from
Date Time Location Tester FIR# Component Name Subcomponent Part# S/N Fault Description Class Dmg Document 1 >> >> >> >> >> Document 2 >> >> >> >> >>
I have attached a copy of the form I need data from.
Clear Form.docx
Unfortunately, some of the info is sensitive to our company so I had to remove two of the content control lists.
I need all of the information that is in red text.
I hope this is enough information.
Thanks in advance to anyone willing to help.
V/r,
-Buhnee
bump for support
Posting Permissions
Reply With Quote
Bookmarks