Can I cross populate fields accross multiple Documents

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.
 
D

Doug Robbins - Word MVP

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
 
Joined
Oct 1, 2013
Messages
1
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top