Can I cross populate fields accross multiple Documents

  • Thread starter Thread starter PaulP
  • Start date Start date
P

PaulP

Word 2007.
I want to create a set of word documents (say 3) where I can fill in data in
any one of the 3 and and the data will automatically populate in the
corresponding field in all the others.
The data can be in all 3, but not necessarily in all of the documents.
I want to be able to save the set and re-use the set many times.
 
The way that I would do this would be to save each of the documents as
templates with { DOCVARIABLE } fields in them where you want the data to be
displayed, Then I would have another template that I would save in the
Word Startup folder so that it was treated as an addin, and in that
template, I would have a userform that contained controls into which the
user would enter the data that you want to appear in the documents and it
would also contain checkboxes for each each of the templates for the
documents that you to create and populate with that data. To use the system
you would a macro in the add-in that would display the userform, then you
would enter the data into the userform and check the box for each of the
templates from which you wanted the documents. Then there would be a
command button that you would click and to Click event of that command
button would check the status of the checkboxes, creating a new documnet
from the associated template if it was checked and would create variables in
the document with the values of the data that had been entered into the
controls on the userform and then update the fields in the document so that
the information would appear in the { DOCVARIABLE } fields.

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm


--
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
 
Hi Doug

This is exactly what I need to do with packs of legal precedents. I have the userform and it works well with the active document, I can open the other precedents but cannot get the docvariable fields to update in any but the active document for which the userform is attached. Could you please expand on your suggestion to place the primary template with the userform in Startup and the code which would then update the fields in the other open documents?

Thank you in anticipation.
 
Back
Top