Global link change from excel to word

[Guest]

I am doing 27 audit reports. All have the same content in terms of excel
worksheets. All are in workbooks with the same names of sheets, after the
initial file name (School ABC.xls/balance sheet; SchoolEFG.xls/balance
sheet, etc.). When I go to make the new report, I am doing a "save as" of
the word document and clicking "update links"and "change source". I then
have to click on each link and re-open, browsing through My Documents to the
new workbook, to change it. Is there a way to quickly globally change ALL
links to my word document to reference the new workbook with the same named
worksheets within? It would save a LOT of time!!!

Thanks!!!

 

[Suzanne S. Barnhill]

You could insert the links with a DocProperty field in place of the "School
ABC" part, then change the corresponding document property in a given
document and update the fields.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

Suzanne,
You are always SO fast and SO helpful. Please help me figure out how I
would insert the links with a DocProperty field. I am not familiar with such
fields. I did just finally figure out, with your help, how to automate the
TOC with fields. It is working well about 80% of the time...which is a great
improvement.

Can you please point me to a reference about these Doc Property fields?

 

[Suzanne S. Barnhill]

The first thing to do is to create the document property (or use one of the
existing ones). Go to File | Properties and select the Custom tab. You could
probably use any one of the properties already there if you didn't care
about the name, or you can create a new one called "School." You won't be
able to add it until you give it a value; this can be a default value such
as "School" that you will change in each new document.

Once you've done this, with the insertion point where you want the field to
go, go to Insert | Field and select DocProperty from the "Field names" list
on the left. This will give you a list of properties, from which you select
School and then click OK.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Guest]

OK...working through this.

I am having trouble figuring out how the relationship exists between my Word
document "Master" and each school's set of excel worksheets.

Does each excel document have a property AND each word report have a
property? Does each worksheet to be linked have to be linked to that
property?

Is there a place I could read more or see more examples of how a workbook
with many sheets gets linked into a word report with several different titles
and pages?

Would it be worthwhile to call Microsoft's Help line or is there another
better resource to talk to for walking me through this template creation?

I finally "GOT" how to use field codes to build my TOC (but now, we are
wanting hanging indents on wrapped lines ARGHHH)....but these document
properties are a whole new study in word programming.

Let me know if you are still willing to help me baby step through this...or
if I need to contact a fee-based resource that you may be able to recommend.