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

Hi Toni,

Very properly, fewi n this ng would be prepared to open unknown attachments,
but may are wiiling to assist.

Try articulating your problem in a short paragraph.


---
Regards,
Norman



"TomBP" wrote in
message ...

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

the formula you show in your posting isn't a hypelink, but a linking formula.
If you have both workbooks open at the same time when you change the name of
the linked to formula, then I believe the link will adjust. Unfortunately,
the linked to workbook has no knowledge of other workbooks that link to it,
so you would have to maintain that information to insure the linking workbook
is opened before doing the name change.

--
Regards,
Tom Ogilvy

"TomBP" wrote:


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