How do you dynamically link word forms to an excel spreadsheet?

[query from MN]

I wish to link many Word forms (the same form, same fields - different data)
into one Excel spreadsheet such that each Word form links to one row in the
Excel spreadsheet for more thorough analysis of the data on the Word forms.
Each field in the Word form will occupy one cell in the Excel row. Any help
would be great.

 

[Helmut Weber]

Hi,

how much code have you got so far?

For a start:

http://word.mvps.org/faqs/interdev/ControlXLFromWord.htm

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

 

[query from MN]

No code written...since I have no knowledge of programming I was hoping to
use something more intuitive - such as functionality inherent in the Macro
functions of Word and Excel. I have a form template in which I thought I'd
have to attach a macro such that all subsequent related uses of this form
would also have the same macro attached. I have begun experimenting with
macros, recording procedures and such but it is not going along well. I am
not able to push data from the Word forms to my one Excel spreadsheet.

 

[Doug Robbins - Word MVP]

Depending upon what sort of Form you are taking about, it might be better to
do it all in Excel. However for some information concerning Word forms, see
this 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