Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Denise
 
Posts: n/a
Default Variable Use in Multiple Documents

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
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Richard O. Neville
 
Posts: n/a
Default Variable Use in Multiple Documents

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



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Denise
 
Posts: n/a
Default Variable Use in Multiple Documents

Awesome, Richard! Thank you so much.

One more question. Is there a way I can put a comment paragraph at the top
of the documents in which I have created these links to explain what I've
done, but that will not print out when the document prints out?
--
Thanks for the help


"Richard O. Neville" wrote:

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




Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
print multiple documents or merge multiple documents into one EE in Need Microsoft Word Help 3 July 16th 05 12:38 AM
Problems merging multiple Word documents Tevibear Microsoft Word Help 2 June 26th 05 12:27 AM
Defining and replacing variable text in multiple Word documents? LisaH Microsoft Word Help 2 March 30th 05 09:51 AM
removing styles across multiple documents jd_editor Microsoft Word Help 1 January 20th 05 10:41 PM
Using Back Arrow when hyperlinking - multiple documents O. Hardin Microsoft Word Help 0 January 13th 05 10:09 PM


All times are GMT +1. The time now is 02:40 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"