Extracting ContentControl Data from a Word Doc into an Excel Sheet for analyzing

[justtrying]

I'm am completely new to VBA and coding in general. What I am trying to do is get user input from a Word doc survey utilizing ContentControls into an Excel workbook for analyzing. Participants will need to select their manager's name, department, and job role from a DropDown ContentControl. They will then read a statement and select 1-5 in a dropdown. There are 15 statements with 15 dropdowns. I would like the completed docs to be uploaded to a shared drive, then using a macro, extract the data from those files for management to analyze. Any help? using Word and Excel 2013

[justtrying]

I am learning VBA as I go so I am not asking for someone to write it out but I would like some help on the actual procedure to extract from a content control drop down, systematically going through each separate word file, and placing it into a workbook

[Kenneth Hobs]

See if these help.

'FormFields
' http://www.mrexcel.com/forum/showthread.php?p=1639696
' http://www.mrexcel.com/forum/showthread.php?t=333200
' http://www.excelforum.com/excel-prog...from-word.html
' Content Controls
' http://www.vbaexpress.com/forum/showthread.php?t=39654

[snb]

In your case I would use a userform in Excel and ignore Word altogether.