Extract Specific Data from MS Word into Excel with VBA

How to extract specific data from MS Word into Excel with VBA automatically.
A sample file for download is available at this link:

[JessmanChicken]

I wasn't sure if I was going to be able to find what I was looking for, so glad I found this, thanks.

[livemylifenow]

Thank you, on point and very informative. Cheers

[adrianocesar]

I'm writing from Brazil. Your code is excellent. Thank you for sharing it!

[shawnrivoire]

Thank you Dinesh. This was very helpful to extract geographical coordinates from a document.

[akinvasion]

Thank you for this awesome tutorial. Every steps have been clarified in very simple language, compelling me to subscribe your channel.

[danielbenefiel]

Excellent. Thanks! Is it possible to have a macro in a Word document that creates a new Excel file and populates data to it? It's more convenient for me to have my macro based in my source word document and have it create the excel spreadsheet.

[BigEngnr]

Very good information...Im not a coder/scripter at all but was able to put this together.
I do have one question...My results seem to be showing line numbers and not the corresponding paragraph numbers using the script. What adjustment do I need to make to grab the actual paragraph section numbers.
Thanks again...
Also can you provide updated links for the support data

[EM-eczo]

Thanks for sharing this! May I know how to modify it so that it can extract from multiple MS Word documents in a specific folder at one go?

[rohinichincholkar]

Can we do this same from text file to word table format?

[jessicamartinez]

This is great! Thank you! My only question... Is there a small change I can make somewhere to make it so that only the text in the paragraph AFTER the search word is put into the cell?

[fyi]

I have a folder with word files with tables of the same template. I want to fetch data from the plains of all word files; please help me out with the code

[MohAboAbdo]

Thank you very much for this great video and for this valuable information.

[mine]

Thank you, this is really great!
Is there a way to have the extracted data copied in the 2nd row of the Worksheet? Many thanks in advance!

[Pixel_Pulse_Creations]

Dinesh, How do I edit your vba code to make it pull the document path from a hyperlink I've made by concat in excel from my spreadsheet? I'd like to pass this information to the script every time I run it so I can use this multiple times on different word docs.

[deepanvikash]

Sir, this is gold. May I know how to populate also the heading of that particular paragraph in one column?

[ExcelMadeEasy]

Sir How to prevent sheet tab names means user can't change sheet name ? VBA

[ebdi]

Thanks for this video. How would you update this if you were extracting from a numbered list instead of paragraphs? Ideally, I would want to record the list number the value occurred at in one cell and the content of that list number in the adjacent cell.

[tranngockimminh]

Could you provide a new link please since I cannot access

[eskobrummel]

Hello and thank you for this useful tutorial! I'm having the following issue when attempting to use your code: when I run the code I get "User defined type not defined" referring to oWord, oDoc, oRange, etc. I have enabled Microsoft Office 16.0 Object Library. Can you think of why I would be having this issue? Thanks

[peterjames]

What if I wanted to return page number instead of paragraph number?