Exporting Word Form Data to Excel

In this video, Neil Malek demonstrates using an Excel macro to get data from multiple Word forms in a folder.

[Marcmenardtechno]

Thanks Neil, this bit of code works very well!

[baileyleppek]

This is so cool. Thank you kind stranger!

[paolosellan]

Hi Neil, I loved your video because your explanations are straight to the point and easy to understand even for non-power users. I need to find a way to import several resumes into a one Excel worksheet. The problem is that each resume is formatted differently. Is it possible to write a memo that looks for specific words (let's say "Education", "Skills", "Experience", etc.) and get related data? Can a macro recognize the name of a particular resume and put it under a field called "name"? Thank you.

[Threedeeh]

will this work even if I used legacy form fields instead of plain text content control?

[pierrickdefossez]

Great video Neil, thanks. How do you deal with check boxes and radio buttons though?

is there away to use the graph on ms word and extract data on to excel?

[yesayawandy]

Hi mr neil, i have a case like this but they are reverse from this case
And then print in word paragraphs like a template
Please help thanks...

[elenitacere]

My question is: Form fields only are for 90 characters and the text that I want to transfer is usually bigger. What can I do?

[masson]

hi Neil, great video, how about in case I have multiple form in same word document? as I want to write them in excel in new line each.
your help will be appreciated.

[manideepak]

Hi sir
I need dump the data from a single ms word which contains several pages of data feilds into a excel spreadsheet
Do you have any macro or an idea to do my work easily

[markddelorme]

Where can I find this VBA code to copy/paste into my workbook? I tried the links provided in Paul Edstein's comments, although these aren't exactly the same as the one your using in the video and I'm getting compile errors. Thanks!

[BigDaddyPoof]

Can you provide a link to the video showing how to create the word form that goes with this excel sheet? I came came across this video first, not the one that shows how to create the word form.

[fbruni]

How cam i export from word doc metadata, using your macro?

[jdortiz]

What about the sub get form data section of the code?

[carltonseymour]

Hi Mike

is it possible to download the VBA code. Thank You

[oneiloneil]

How to transfer info from 1 document field into another doc fields....

[sathishjay]

Thank you. Here in my word data contain Heading 1, heading 2, heading 3 etc. From like this i wanna export to excel those headings are set in separate vice like heading 1 first columns heading 2 secomd column and heading 3 third column again second heading 1 second row first column as well heading 2 secomd column like this heirarchy i want know extract data to there any way to do in automation.please could you assist.

[kingpinsascha]

Set oFolder = CreateObject("Shell.Application").BrowseForFolder(0, "Choose a folder", 0) "

Can you tell me which task the last sign has (quotation marks)? I deleted ist due to compiling reasons. thanks

Dear Neil, what is the status of repeatitive forms fields ( like kids ) ?

[bapimazhar]

Hi Mike, How can I download VBA code for this macro?
Thanks.