buhnee
New member
- Joined
- Jan 18, 2022
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016 MSO (V 2112)
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/showthread.php?8900-Help-with-VBA-to-extract-data-from-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
I have attached a copy of the form I need data from.
View attachment 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
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/showthread.php?8900-Help-with-VBA-to-extract-data-from-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.
View attachment 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