VBA Word Table to Excel Help

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

DateTimeLocationTesterFIR#Component NameSubcomponentPart#S/NFaultDescriptionClassDmg
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
 
bump for support
 
Back
Top