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/g1...rlink1adj.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/g1...yperlink2.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/g1...yperlink3.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/g1...yperlink4.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:
--------------------
='[123456.xls]Data Invoer '!$F$2
--------------------


Thanks in advance


--
TomBP
------------------------------------------------------------------------
TomBP's Profile: http://www.excelforum.com/member.php...o&userid=36112
View this thread: http://www.excelforum.com/showthread...hreadid=561001