T
TomBP
Hi everyone,
I just discovered all my macro's are useless because I have a hyperlink
problem. Let me explain the situation.
[image:
http://i54.photobucket.com/albums/g115/TomBP/Hyperlink1adj.jpg]
As you see I start with an xls file called Receipt Note I - MRN BP.xls.
This file has a hyperlink to CMR BULK.xls.
[image: http://i54.photobucket.com/albums/g115/TomBP/Hyperlink2.jpg]
If you look at cell F2 in Receipt Note I - MRN BP.xls I filled in the
word test. In CMR BULK.xls this word is linked by using the following
function:
Code:
--------------------
='[Receipt Note I - MRN BP.xls]Data Invoer '!$F$2
--------------------
So far so good
[image: http://i54.photobucket.com/albums/g115/TomBP/Hyperlink3.jpg]
Now I have a Save button and when I press this the Receipt Note I - MRN
BP.xls is saved as 123456.xls
[image: http://i54.photobucket.com/albums/g115/TomBP/Hyperlink4.jpg]
Now when I click the hyperlink to CMR BULK.xls you can see the word
Test is not there. This is because it still refers to:
Code:
--------------------
='[Receipt Note I - MRN BP.xls]Data Invoer '!$F$2
--------------------
Does anyone know a solution for this that this code automatically
adjusts to:
Code:
I just discovered all my macro's are useless because I have a hyperlink
problem. Let me explain the situation.
[image:
http://i54.photobucket.com/albums/g115/TomBP/Hyperlink1adj.jpg]
As you see I start with an xls file called Receipt Note I - MRN BP.xls.
This file has a hyperlink to CMR BULK.xls.
[image: http://i54.photobucket.com/albums/g115/TomBP/Hyperlink2.jpg]
If you look at cell F2 in Receipt Note I - MRN BP.xls I filled in the
word test. In CMR BULK.xls this word is linked by using the following
function:
Code:
--------------------
='[Receipt Note I - MRN BP.xls]Data Invoer '!$F$2
--------------------
So far so good
[image: http://i54.photobucket.com/albums/g115/TomBP/Hyperlink3.jpg]
Now I have a Save button and when I press this the Receipt Note I - MRN
BP.xls is saved as 123456.xls
[image: http://i54.photobucket.com/albums/g115/TomBP/Hyperlink4.jpg]
Now when I click the hyperlink to CMR BULK.xls you can see the word
Test is not there. This is because it still refers to:
Code:
--------------------
='[Receipt Note I - MRN BP.xls]Data Invoer '!$F$2
--------------------
Does anyone know a solution for this that this code automatically
adjusts to:
Code: