Extract Specific Data from MS Word into Excel with VBA

preview_player
Показать описание
How to extract specific data from MS Word into Excel with VBA automatically.
A sample file for download is available at this link:
Рекомендации по теме
Комментарии
Автор

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

JessmanChicken
Автор

Thank you, on point and very informative. Cheers

livemylifenow
Автор

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

adrianocesar
Автор

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

shawnrivoire
Автор

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

akinvasion
Автор

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.

danielbenefiel
Автор

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

BigEngnr
Автор

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?

EM-eczo
Автор

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

rohinichincholkar
Автор

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?

jessicamartinez
Автор

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

fyi
Автор

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

MohAboAbdo
Автор

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!

mine
Автор

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.

Pixel_Pulse_Creations
Автор

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

deepanvikash
Автор

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

ExcelMadeEasy
Автор

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.

ebdi
Автор

Could you provide a new link please since I cannot access

tranngockimminh
Автор

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

eskobrummel
Автор

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

peterjames