Extract Data from Word Document Using Word and Excel VBA

[@temuradhamson]

Hello Dinesh, your video is amazing and underrated! 👍

[@1stclassmedia]

nice simple code that executes well, suggestion would be to remove any formatting from source document as a elements such as hyperlinks can break the code execution.

[@Khalnayak_sanju143]

Very nice and Brilliant code created

[@Exceltrainingvideos]

Glad you like it! Please share the Excel VBA tutorial with your friends also.

[@manishkasana99]

Thank you sir, This code running but, Upgrade this code with Add [ Text, image(png, jpg), maths equation, Entry button, etc ] ❤

[@nikitalakkundi5755]

Excellent video sir! saved hrs of my life! I wish to extract highlighted data instead of data in brackets please guide!

[@Exceltrainingvideos]

Glad it helped. This link will guide: www.exceltrainingvideos.com/identify-colored-cells-excel-worksheet-and-perform-actions/

[@usmansardarmuhammad961]

Hey Thank you for this help. Stay Blessed.

[@Exceltrainingvideos]

You're welcome!

[@shoutthesilence9156]

I'm trying this on a macro enabled word document (docm files) which things should i change in this code to make it work?

[@Exceltrainingvideos]

Totally different way of working from Word!

[@AB-zw3zg]

Thank you so much, ¡Brilliant!. Anyway, please, could it be possible that the text format (from Word) will be transferred to the Excel? And if possible, could you teach the code to be added to the code in this video? Tank you very much. Cheers, Alberto

[@ORANGEPICTURESOFFICIAL]

Simply how to do vlookup function when any data is in filter. For visible cells only we have to lookup using match function for headers mapping.

[@Exceltrainingvideos]

Query not clear.

[@ORANGEPICTURESOFFICIAL]

Sorry for spelling mistake. Vlookup when data is in filter. Using match for headers. Ex: filter completed when we have to lookup for pending. But the columns are not in sequence.

[@Exceltrainingvideos]

Noted

[@ORANGEPICTURESOFFICIAL]

@@Exceltrainingvideos: thank you. Waiting for video sir

[@ORANGEPICTURESOFFICIAL]

Simply superb sir. Please do a video on filtered data. Vlookup. How to do visible cells vlookup. Please sir

[@Exceltrainingvideos]

Already uploaded. Search this channel or our website: www.exceltrainingvideos.com/

[@vigneshr2828]

Thanks a lot. That's really helpful

[@Exceltrainingvideos]

Glad it was helpful! Please share the VBA tutorial with your friends.

[@jorgan2028]

Can this be used to get some data from word and then add it to the meta data of the file? then adding it to say the "TAG" properties?

[@Exceltrainingvideos]

Try it out!

[@jorgan2028]

@@Exceltrainingvideos I have and it doesn't work.

[@srikanthkandalam4051]

hi sir. I have a case. with a worksheet of multiple columns. each data in the column may refer to another sheets on a lan or share point are which need to be validated second. if one cell value is given. based on cell value next column to be populated based on validation from different sheet. I may have 100 plus reference sheets where data to be validated. is that a possible case. can you help me sir

[@Exceltrainingvideos]

Noted

[@snehachowdary1202]

Hello sir, I’m running into an issue here. When I ran the code for the word document, I could only run for the first page, my results from the second page is not showing up. Also my word document contains text that I want to search for and copy to excel. Is there a video of yours I could look at for more detail? Thanks for all your help in advance

[@Exceltrainingvideos]

Please search the channel. To get data from multiple pages in your word document, you'll have to use a looping process.

[@anilkoli5190]

can we export date from multiple word files, copying those to excel ?

[@Exceltrainingvideos]

Should be possible.

[@ORANGEPICTURESOFFICIAL]

Tqs for the reply sir. But there is no video for how to do vlookup for multer data using match.

[@Exceltrainingvideos]

What is multer data?

[@អនុវិទ្យាល័យបឹងនិមល]

Can you show VBA How to auto transfer data to another sheet by using date?

[@Exceltrainingvideos]

This VBA tutorial link will guide: www.exceltrainingvideos.com/tag/copy-data-based-on-date-criteria/ Or search www.exceltrainingvideos.com

[@អនុវិទ្យាល័យបឹងនិមល]

Thanks so much

[@schmekis1]

Use this exact code but I'm getting a "Compile error: User-defined type not defined" and it is referring to... cDoc As Word.Document

[@siba720]

Thanks for sharing... Great learning experience. Can it possible to extract a sentence after find a specific word on it?

[@siba720]

Could you please take another session on this?

[@Exceltrainingvideos]

Yes you can! Try it out!

[@shoaibsaifi9806]

Hi Sir. I am running into an error while running this code. when I run the code first time it works fine but when I run it for the second time it throws the error on the below line set cDoc=ActiveDocument the error is read as "the remote server machine does not exist or unavailable." Please advise how to remove this error.

[@Exceltrainingvideos]

Just save and close the document in the first extraction.

[@shoaibsaifi9806]

Still not working Sir. I got 462 error.

[@shoryaarora1464]

Interesting

[@Exceltrainingvideos]

Glad you found the Excel VBA tutorial interesting. Please share with your friends too.