J
jmarch42
Good morning, all.
I am trying to automate our version control process so we don't get smacked
by ISO auditors and I'm having some difficulty.
Currently, we have all ISO documents on one network share with each section
being its own word document. Within each document is contained a Revision
letter (A, B, C, D, etc). Then, we have a master revision level tracking
document (currently word but this could be changed to excel if necessary)
that contains a list of all ISO documents and their current revision (A, B,
C, D, etc.).
The goal is to just be able to update the Revision letter in each document,
and then have the master revision level tracking document (either by links or
whatever will work!) update itself with the individual documents' revision
letters.
I've tried doing this with Bookmarks and links in word--and it works...until
you change a document's revision letter. Because the bookmark lets you select
and mark highlighted text (e.g "E"), when the "E" is changed to "F", the
bookmark disappears as soon as the "E" disappears, rendering the link useless.
Next I tried embedding an excel sheet (for a single cell in which to place
the revision letter) in the section documents so that I could instead
reference the cell (which would allow data to be changed and referenced
without the use of bookmarks), but I cannot seem to successfully link it, and
my guess is because it's embedded. I used:
LINK Excel.Sheet.8 "DOCUMENTNAME" "Sheet1!R1C1:R1C1" \a
as well as LINK Word. Document.8 "DOCUMENTNAME" "Sheet1!R1C1:R1C1" \a
and a myriad of other trial and errors.
So, that all being said....Anyone have any ideas? I am open other ways to do
this too, of course--I just need something simple.
Thanks, all, in advance!
I am trying to automate our version control process so we don't get smacked
by ISO auditors and I'm having some difficulty.
Currently, we have all ISO documents on one network share with each section
being its own word document. Within each document is contained a Revision
letter (A, B, C, D, etc). Then, we have a master revision level tracking
document (currently word but this could be changed to excel if necessary)
that contains a list of all ISO documents and their current revision (A, B,
C, D, etc.).
The goal is to just be able to update the Revision letter in each document,
and then have the master revision level tracking document (either by links or
whatever will work!) update itself with the individual documents' revision
letters.
I've tried doing this with Bookmarks and links in word--and it works...until
you change a document's revision letter. Because the bookmark lets you select
and mark highlighted text (e.g "E"), when the "E" is changed to "F", the
bookmark disappears as soon as the "E" disappears, rendering the link useless.
Next I tried embedding an excel sheet (for a single cell in which to place
the revision letter) in the section documents so that I could instead
reference the cell (which would allow data to be changed and referenced
without the use of bookmarks), but I cannot seem to successfully link it, and
my guess is because it's embedded. I used:
LINK Excel.Sheet.8 "DOCUMENTNAME" "Sheet1!R1C1:R1C1" \a
as well as LINK Word. Document.8 "DOCUMENTNAME" "Sheet1!R1C1:R1C1" \a
and a myriad of other trial and errors.
So, that all being said....Anyone have any ideas? I am open other ways to do
this too, of course--I just need something simple.
Thanks, all, in advance!