Hyperlink problem

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:
 
N

Norman Jones

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.
 
T

Tom Ogilvy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top