Quickly compile Form Field data from multiple forms in Excel?

[Guest]

I am trying to build a Word 2003 form that will allow me to quickly compile
data from the fields in Excel. So if I have 200 forms, I will be able to
open excel, update it with the completed form fields and have each Field
occupy a different row. e.g:
Name(field 1) Dept (field 2) Salary (field 3)
bob Sales 40k
mary Finance 30k
joe Marketing 80k

Any help is greatly appreciated.

 

[Doug Robbins]

See the last of the following series of articles

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Guest]

thank you!