Thanks Neil, this bit of code works very well!

Really helpful! Thanks Neil!

@vishakhabhuibhar9508

6 жыл бұрын

hey did you find the code?

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

This is so cool. Thank you kind stranger!

@thekingsman8784

3 жыл бұрын

kzread.info/dron/y1BPfbGIoP6Bei7feTB7zA.html Open this link and increase your computer knowledge

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.

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

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

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

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.

Thank you Sir!!

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

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

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!

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

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

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.

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?

Wheres the Macro Download link

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

How do I get as copy of the VBA Macro?

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

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.

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

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

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

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

@pradeepchauhan3085

4 жыл бұрын

will you please sent me a script code of this word form data to excel. my email id ayush.kumar916@gmail.com

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?

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

6 жыл бұрын

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

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

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

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

6 жыл бұрын

me too

What if there are checkbox selections?

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

8 жыл бұрын

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.

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

3 жыл бұрын

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

3 жыл бұрын

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

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

4 жыл бұрын

look up Mail Merge

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

2 жыл бұрын

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

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

5 жыл бұрын

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

4 жыл бұрын

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

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

2 жыл бұрын

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

2 жыл бұрын

@Daxton Lukas instablaster ;)

@daxtonlukas8892

2 жыл бұрын

@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

2 жыл бұрын

@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

2 жыл бұрын

@Daxton Lukas you are welcome :)

Word object model?

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

@colinm5120

5 жыл бұрын

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

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

6 жыл бұрын

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

4 жыл бұрын

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

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

@bayonictx8305

4 жыл бұрын

you figured it out?

@fireball60004

4 жыл бұрын

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

did anyone figure out the references

hi...where is the macro code?

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

Where is the downloadable macro?

@siebertpj

5 жыл бұрын

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

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

7 жыл бұрын

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.

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

@kirannikam2500

6 жыл бұрын

Hi Johan, were u successful in running the macro

@katytillman6004

6 жыл бұрын

Did you find the download for the macro?

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.

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

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

4 жыл бұрын

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

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

5 жыл бұрын

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

4 жыл бұрын

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

@bayonictx8305

4 жыл бұрын

@@colinm5120 please help :'(

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

5 жыл бұрын

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

so, wheres the code?

@SophiaKMarques

6 жыл бұрын

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

8 ай бұрын

Did you ever get the file?

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

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

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