S
sooner1ksn
I have encountered a problem. Workbook "A" contains several columns of
information, some of which is sensitive, and therefore of limited
access. There are several columns of information, which is
periodically updated. Workbooks "B" and "C" each contain some of the
information from Workbook "A", in a limited form (i.e. of 20 columns in
"A", "B" might contain 4 columns, and "C" might contain 5 different
columns).
Two of the columns in "A" (one of each ends up in "B" and "C") consists
of hyperlinks to documents that reside on a different server within the
organization, such that when you click the link, the document opens.
For the sake of this discusssion, let's say that these documents live a
"\\OtherServer\Main\Sub1\SubSub1\file1" and
"\\OtherServer\Main\Sub2\SubSub2\file2". So the hyper link would be to
that location. When new data comes in, it is updated in Workbook "A"
manually. Then the relevant parts from "A" are copied and pasted into
"B" and "C".
Here's where the problem arises. When copying
"\\OtherServer\Main\Sub1\SubSub1\file1" from "A" to "B", what ends up
in "B" is "\\OtherServer\Main\Sub1\Main\Sub1\SubSub1\file1", and when
someone clicks the link, it errors, since obviously that file doesn't
exist. It happens every time a copy and paste is performed, and it
always duplicates the 2nd and 3rd levels of the path: i.e. "\Main\Sub2"
becomes "\Main\Sub2\Main\Sub2".
"A", "B" and "C" all reside within the same folder, but it is different
than the folder where the linked files are. I don't think that has
anything to do with it, but not sure.
Help anyone?
information, some of which is sensitive, and therefore of limited
access. There are several columns of information, which is
periodically updated. Workbooks "B" and "C" each contain some of the
information from Workbook "A", in a limited form (i.e. of 20 columns in
"A", "B" might contain 4 columns, and "C" might contain 5 different
columns).
Two of the columns in "A" (one of each ends up in "B" and "C") consists
of hyperlinks to documents that reside on a different server within the
organization, such that when you click the link, the document opens.
For the sake of this discusssion, let's say that these documents live a
"\\OtherServer\Main\Sub1\SubSub1\file1" and
"\\OtherServer\Main\Sub2\SubSub2\file2". So the hyper link would be to
that location. When new data comes in, it is updated in Workbook "A"
manually. Then the relevant parts from "A" are copied and pasted into
"B" and "C".
Here's where the problem arises. When copying
"\\OtherServer\Main\Sub1\SubSub1\file1" from "A" to "B", what ends up
in "B" is "\\OtherServer\Main\Sub1\Main\Sub1\SubSub1\file1", and when
someone clicks the link, it errors, since obviously that file doesn't
exist. It happens every time a copy and paste is performed, and it
always duplicates the 2nd and 3rd levels of the path: i.e. "\Main\Sub2"
becomes "\Main\Sub2\Main\Sub2".
"A", "B" and "C" all reside within the same folder, but it is different
than the folder where the linked files are. I don't think that has
anything to do with it, but not sure.
Help anyone?