As coded, the macro in the link harvests data from all formfields and content controls. It would be a trivial undertaking to replace the loops with iterative code that just looks at nominated formfields and outputs their results to nominated cells in the Excel workbook.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|