PDA

View Full Version : Extracting ContentControl Data from a Word Doc into an Excel Sheet for analyzing



justtrying
07-15-2015, 09:44 AM
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
07-15-2015, 12:28 PM
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
07-16-2015, 09:53 AM
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-programming/799070-import-text-fields-from-word.html
' Content Controls
' http://www.vbaexpress.com/forum/showthread.php?t=39654

snb
07-16-2015, 11:45 AM
In your case I would use a userform in Excel and ignore Word altogether.