Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print multiple documents or merge multiple documents into one | Microsoft Word Help | |||
Problems merging multiple Word documents | Microsoft Word Help | |||
Defining and replacing variable text in multiple Word documents? | Microsoft Word Help | |||
removing styles across multiple documents | Microsoft Word Help | |||
Using Back Arrow when hyperlinking - multiple documents | Microsoft Word Help |