Create an Excel sheet with the different variables and their identification
in columns. For the first variable--let's say it's "Dues"--enter the current
amount, say, $25.00. Format (Format Cells menu) all the cells with the same
font and number format you want to show up in the Word document (e.g. Times
New Roman 12, currency with two decimal places). Now, click on the cell with
the $25.00 and copy it.

Switch to your Word document and go to the place where you want the dues
amount to appear. Select Edit-Paste Special; in the next menu check "Paste
Link" and in the box with several selections select "Formatted Text." This
will enter the dues amount into your Word document and will update the
amount anytime you change the source Excel document. You will have to repeat
this process for every dynamic entry in every document, but you'll only have
to do it once. Thereafter, any update involves simply entering the new
amount into the Excel sheet.

"Denise" wrote in message
...
I have several documents that list the same information, such as the
current
amount for monthly dues to our cabana club. Every time the dues change,
someone has to edit each document to change the amount. I would like to
create a variable and set the value in one place, but use the variable in
multiple documents. It looks like I might be able to do this with a doc
variable. But I don't quite understand how to do it. I see thread with
the
subject Set Variable in VBA, use in document, dated 11/29/2005, which
talks
about it. My problem is I don't know where to create the variable in the
first place. Do I do it right in my Word document, or do I do it
somewhere
else? Also, how do I make it so the variable can be used in multiple
documents?

--
Thanks for the help