Transferring data from a word document form to Excel 2010

Hello!

I am trying to consolidate numerous word document forms into an excel table - I know that this can be done using VBA (probably through a ADODB connection?), but I have no idea how to do it. I've googled some possible codes, and have bookmarked each form field with a unique name to enable it to be picked up through VBA, but don't know know where to go from there (particularly regarding checkboxes where the choice determines what is put onto the spreadsheet).

I have attached the form template, complete with bookmarked fields, and the excel form that I would like the information to go into (I've added notes for with which information is required). If I haven't included enough information regarding my problem then please let me know. The forms will all be saved in one specific folder.

Any help would be much appreciated!

Thanks,

Claudia

Hi - is there any more information I need to add to this? I could really do with some help.

Thanks