Quickly compile Form Field data from multiple forms in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top