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.
Macro development by the estimable Paul Edstein - mvp.microsoft.com/en-us/Publi...

[@Marcmenardtechno]

Thanks Neil, this bit of code works very well!

[@Threedeeh1]

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

[@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...

[@masson426]

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.

[@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!

[@11111111111111169976]

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

[@bapimazhar1166]

Hi Mike, How can I download VBA code for this macro? 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?

[@fbruni]

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

[@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

[@francisprice762]

Hi Neil Where can I obtain a copy of VBA macro code for this example.

[@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.

[@manideepak6820]

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

[@carltonseymour869]

Hi Mike is it possible to download the VBA code. Thank You

[@pierrickdefossez3157]

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

[@sathishjay8405]

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 excel......is there any way to do in automation.please could you assist.

[@8929199]

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

[@squeekybean89]

Really helpful! Thanks Neil!

[@vishakhabhuibhar9508]

hey did you find the code?

[@paolosellan9445]

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.

[@chuckallaire566]

Wheres the Macro Download link

[@jdortiz86]

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

[@pradeepchauhan3085]

Hi Neil, how can i get this work to excel export notepad file.

[@robinleroy1373]

How do I get as copy of the VBA Macro?

[@iKrromz]

Thank you Sir!!

[@ritaa.510]

I get stopped when exiting out of VBA with a message that the highlighted line "Sub GetFormData ( )" will stop the debugger....suggestions? Thanks!

[@pradeepchauhan3085]

will you please sent me a script code of this word form data to excel. my email id [e-mail]

[@baileyleppek]

This is so cool. Thank you kind stranger!

[@thekingsman8784]

kzbin.info/door/y1BPfbGIoP6Bei7feTB7zA Open this link and increase your computer knowledge

[@kristensagnes2594]

I was able to get this to work but now that I've put a few in there, when I import now it is copying over previous ones instead of adding new ones. Any ideas how to fix?

[@oneiloneil1970]

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

[@adnanmahmud8691]

Where is the code file? Can't find it on the link shared at the description.

[@lauraashleyfiddle]

Where do I get the code to cut and paste? Thanks! Also, I only have one word .doc so do I have to do Macros in order to import data from .doc to .xls?

[@lauraashleyfiddle]

Also it would be nice to see what the .docs you have in your folder look like prior to import.

[@ssorensonaz]

How do you change this macro to refer to bookmarks, instead of content controls? I have a ton of older word forms I need to mine for data, and this macro won't read them...because they were all created prior to content controls. In fact, some of the fields have the same bookmark name as each other. I just need to dump out all the data in hundreds of files into excel.

[@Tomas-eb7qj]

me too

[@eliot587]

Neil, I'm stuck. How does the excel macro recognize your word macro form field data and know which column to place the data? The issue I'm having with this excel macro is that my code doesn't recognize the Word Object Model despite toggling the reference to the Word 14.0 Object Model Library. What can I do to get around the issue I'm having? What can I do to fix my .xlsm and docm, so that my data will be collected from the form fields and placed into my spreadsheet?

[@lmt125]

I think you need to make sure all your field have the same name like text1, text2 in your docm haven't tried this myself yet.

[@tele5050]

Hi Malek, its wonderful demo. However I am having some issue in populating my excel sheet. I have email you the files. Appreciate if you help to resolve. Thanks a lot.

[@dorito818]

What if there are checkbox selections?

[@hariraghava6745]

I have a word file but the details are not in a particular sequence as you have shown in the word file,, it's a 20+ page file and I need some 60 fields from the word form.. I tried your coding with little changes but it didn't work can you please guide me how to do this..

[@subbavenkiteswaran4433]

I am in a similar situation, did you find a solution for your problem ?

[@valeriebigeard362]

Hi Mr Neil, I do not find your notepas file with the whole script of the macro? It would be possible to get it please? Kind regards

[@nadinekadri6701]

Hi Valerie, you can find the code online here: www.vbaexpress.com/forum/showthread.php?40406-Extracting-Word-form-Data-and-exporting-to-Excel-spreadsheet

[@mightybluespider]

@@nadinekadri6701 "Compile error: Method or data member not found"

[@jmrcardoso73]

Any suggestion on how to do the opposite i.e I have an excel table and want to populate word forms with that? Thx

[@theigneous]

look up Mail Merge

[@jdortiz86]

Word object model?

[@vilsaflasche]

hi Neil, great explaining. it is easy to follow. however, i have been trying to do this on a Mac but it doesn't run. do you have an idea why? thanks

[@daxtonlukas8892]

you all prolly dont care at all but does any of you know a tool to get back into an instagram account? I was stupid forgot my login password. I appreciate any help you can offer me.

[@bradleycharles9108]

@Daxton Lukas instablaster ;)

[@daxtonlukas8892]

@Bradley Charles i really appreciate your reply. I got to the site on google and im trying it out atm. Takes quite some time so I will get back to you later when my account password hopefully is recovered.

[@daxtonlukas8892]

@Bradley Charles It did the trick and I finally got access to my account again. Im so happy:D Thanks so much, you really help me out !

[@bradleycharles9108]

@Daxton Lukas you are welcome :)

[@linotaffoni2820]

hi...where is the macro code?

[@aboyoussef4026]

Thank you very much sir, could you please give me this excel file?

[@DSTGotchaGood]

You didn't come back and explain what we have to do with "'Note: this code requires a reference to the Word object model" ?

[@raprein3]

In the Visual basics screen go to the top bar and click Tools>References. Then simply scroll the list and tick the boxes of ALL the items with the words Object Model in it (preferably search for Windows Object model or Word Object model and also tag all Object libraries. I don't know exactly which one made it actually work, but after clicking them all it worked perfectly! Good luck!

[@prabhupatra]

@@raprein3 Is there any other way to deal with the same error message; because References is disabled on my work laptop on which I need to execute this code.

[@mgunter9929]

where is the Word to excel export file referenced as a download for this video?

[@colinm5120]

His VBA code is on Forum post here: www.vbaexpress.com/forum/showthread.php?40406-Extracting-Word-form-Data-and-exporting-to-Excel-spreadsheet&p=257696&viewfull=1#post257696

[@bartleybonar5724]

did anyone figure out the references

[@jdortiz86]

Hey Neil this was great! Where can I find the code you used? Also what video do you go over making changes to a word doc to fit what you need to populate an excel file?

[@colinm5120]

His VBA code is on Forum post here: www.vbaexpress.com/forum/showthread.php?40406-Extracting-Word-form-Data-and-exporting-to-Excel-spreadsheet&p=257696&viewfull=1#post257696

[@phmaktx3343]

@@colinm5120 so this link seems to be dead. Any suggestions where else I can get the macro code? thx!!

[@wiremylights]

Can anybody help me??? I have address and phone numbers in word 209 pages. I want to export from word to excel (open office) in name, address, state, email, website and telephone number. It has been a pain. can anyone help. tried comma's, saving as plain text etc nothing works. the data is still all over the place.

[@neilmalek]

I really don't know what's happening under the hood with Open Office, so if everything's breaking, I'd be doing the same Googling you are! Sorry I can't be of more assistance.

[@MsMRBEER]

Neil please provide VBA code. This looks exactly like what I need.

[@ShankarKumar-zo1fb]

I am getting compile error "Can't Find Project or Library" high lighting "wdApp As New Word.Application"

[@bayonictx8305]

you figured it out?

[@fireball60004]

You need to 'enable' (excuse any misunderstanding there please!) the reference to the Word object from within the VBA window following Tools > References > Microsoft Word Object Library

[@kingpinsascha]

Hey Neil, "Object doesn't support property or method" afterwards I get "excel is waiting for an ole action from another application" Should I deactivate or activate sth in Word?

[@mastrockys]

Hi, Did you get a response to this / moved ahead from here? I am stuck at the same place!

[@TheZedraCula]

Hi, Maybe i'm blind but where is the download for the macro?

[@kirannikam2500]

Hi Johan, were u successful in running the macro

[@katytillman6004]

Did you find the download for the macro?

[@dawarner6302]

Neil... it has been a couple of years since you created this video... by chance, is the MACRO text file still available? I would like to use it if possible

[@colinm5120]

His VBA code is on Forum post here: www.vbaexpress.com/forum/showthread.php?40406-Extracting-Word-form-Data-and-exporting-to-Excel-spreadsheet&p=257696&viewfull=1#post257696

[@bayonictx8305]

@@colinm5120 I get error :( Compile error: User- defined type not defined what references i should use?

[@bayonictx8305]

@@colinm5120 please help :'(

[@1truebloodlove]

Where is the downloadable macro?

[@siebertpj]

Found this online- links4reference.yolasite.com/resources/Step%20to%20create%20macro%20(VBA%20for%20Word%20form%20fields%20to%20Excel).pdf

[@Ewan-Argo]

so, wheres the code?

[@SophiaKMarques]

www.vbaexpress.com/forum/showthread.php?40406-Extracting-Word-form-Data-and-exporting-to-Excel-spreadsheet&p=257696&viewfull=1#post257696 Found it on his blog

[@ociekhan317]

Did you ever get the file?

[@WadeBarmby]

This is a great video, but it would actually be useful if there were downloads to the files and the VB code he's talking about. Hard to copy and paste from a video. If anyone has them, it would be very much appreciated.

[@colinm5120]

His VBA code is on Forum post here: www.vbaexpress.com/forum/showthread.php?40406-Extracting-Word-form-Data-and-exporting-to-Excel-spreadsheet&p=257696&viewfull=1#post257696

[@fullmetalsvr]

People you can do this, they just don't know how... pointless to show and not give the examples to download...

[@vicentemoll3618]

Sub GetFormData() ' Note: this code requires a reference to the Word object model Application.ScreenUpdating = False Dim wdApp As New Word.Application Dim wdDoc As Word.Document Dim FmFld As Word.FormField Dim strFolder As String, strFile As String Dim WkSht As Worksheet, i As Long, j As Long strFolder = GetFolder If strFolder = "" Then Exit Sub Set WkSht = ActiveSheet i = WkSht.Cells(WkSht.Rows.Count, 1).End(xlUp).Row ' on this line, notice that the file extension is .docm. ' if you are using .doc files or .docx files, make sure ' you change this line to match up with that. ' strFile = Dir(strFolder & "\*.docm", vbNormal) While strFile "" i = i + 1 Set wdDoc = wdApp.Documents.Open(Filename:=strFolder & "\" & strFile, _ AddToRecentFiles:=False, Visible:=False) With wdDoc j = 0 For Each FmFld In .FormFields j = j + 1 WkSht.Cells(i, j) = FmFld.Result Next FmFld End With wdDoc.Close SaveChanges:=False strFile = Dir() Wend wdApp.Quit Application.ScreenUpdating = True End Sub Function GetFolder() As String Dim oFolder As Object GetFolder = "" Set oFolder = CreateObject("Shell.Application").BrowseForFolder(0, "Choose the folder", 0) If (Not oFolder Is Nothing) Then GetFolder = oFolder.Items.Item.path Set oFolder = Nothing End Function 'If you decide to use Content Controls instead of Form Fields '(which are found under the Developer Ribbon), you'll need to find every instance 'of FmFld and replace it with CntCtrl. ' Dim CntCtrl As Word.ContentControl 'For Each FmFld In .FormFields changes to For Each CntCtrl In .ContentControls 'WkSht.Cells(i, j) = FmFld.Result changes to WkSht.Cells(i, j) = CntCtrl.Range.Text

[@c3235086]

Worse than useless without the macro file, which is not provided.