Hi everyone,
I just discovered all my macro's are useless because I have a linking formula problem. Let me explain the situation.
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.
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:
So far so good
Now I have a Save button and when I press this the Receipt Note I - MRN BP.xls is saved as 123456.xls
Now when I click the hyperlink to CMR BULK.xls from the 123456.xls document you can see the word Test is not there. This is because it still refers to:
Does anyone know a solution for this that this code automatically adjusts to:
Thanks in advance
I just discovered all my macro's are useless because I have a linking formula problem. Let me explain the situation.
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.
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
Now I have a Save button and when I press this the Receipt Note I - MRN BP.xls is saved as 123456.xls
Now when I click the hyperlink to CMR BULK.xls from the 123456.xls document 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