Copy Data from Microsoft Word to Excel using Excel VBA

This video demonstrates how to copy data from Microsoft Word content controls to and Excel worksheet using Excel VBA. The code in this example is designed to copy data from multiple MS Word content controls including rich text, date picker, and drop down list.

[brandiependergast]

This video provided every step necessary to copy my data from a Word document into an Excel spreadsheet. I can assure you I will be back to watch this a few more times in my ventures of uploading data into an Excel format. Thank you!

[kaitlynforaker]

This is new to me. I have never used this before. I have to admit this confuses me however this video helped me gain knowledge of this topic.

[johnharrisjr]

Copying Data from Microsoft Word to Excel using Excel VBA is all new to me. The video gave a great explanation but I need to try this on my own to get it

[veronicabetz]

This information is new to me, but appears to be very helpful tool.

[daveheartgames]

Great help, can you think of a way to do this without content controls in multiple word documents? For example a client gives us 10 files 1.doc through to 10.doc and we want to copy two ‘fields’ in the word document and put them into excel. The routine should be able to process many files in a folder

[uniQue_XL]

Thanks a lot. Great explanation!
Can I save both Word File and Excel file on cloud (OneDrive/DropBox etc'...) and use it from my/Others Mobile phone in order to collect data from different users via the Word document ?

[ValmisFilm]

hi! how can I get data from txt file? no tables! I mean like I would open Notepad, select all, copy it and paste it to excel - how could I do that?

[yo_swarnali]

I'm getting run time error 91 for that line including Sheets("Data").Cells(r, 2)....