Hyperlink problem:my macro's

Hi everyone,

I just discovered all my macro's are useless because I have a hyperlink problem. Let me explain the situation.

\1

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.

\1

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:

Please Login or Register  to view this content.

So far so good

\1

Now I have a Save button and when I press this the Receipt Note I - MRN BP.xls is saved as 123456.xls

\1

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:

Please Login or Register  to view this content.

Does anyone know a solution for this that this code automatically adjusts to:

Please Login or Register  to view this content.

Thanks in advance

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>