I have been given the task of taking almost 30 Word docs and extracting the information and compiling it into Excel. I began doing this manually by using Find/Replace which is how I was able to complete the first 3 sheets, however, this is cumbersome and time consuming and these will need updating on a regular basis. I have seen multiple threads on this topic but I am not proficient enough with VBA to modify the code to work for my needs. I have attached examples of both the Excel spreadsheet and samples of the Word docs I'll be using. The Excel workbook already has several sheets filled in as an example of what the completed project should look like. Basically, the macro needs to open up the document correlating to the name of the sheet (each one is unique), extract the UID, Abbreviation, Alias, Name, and Units and place them on the same row under their respective column starting on ROW 5 then move to the next row and do the same. Once all the data has been extracted (and each sheet has a unique number of rows) then the document is to be closed and the sheet formatted as in the example sheets to highlight the data. Thanks for any help or guidance you can provide.
Here is the link to the files on OneDrive:
Also asked here
Macro to extract text from Word doc
Here is the link to the files on OneDrive:
Also asked here
Macro to extract text from Word doc
Last edited by a moderator: