create a link between two Excel files which can be dynamic. VBA code.

[KlausW]

Hello everyone

Can you create a link between two Excel files which can be dynamic. VBA code.

So that you can change the name in B11 also function the link with a new name.

What the link looks like when it is not dynamic.

='D:\DNBR 2024\Service lists\Service lists\[NK.xlsm]NK'!C12

As I think it can look like if it is Dynamic

='D:\DNBR 2024\Service lists\Service lists\[B11.xlsm]B11'!C12

The link must work on the following cells C12 to NC 15.

Does that make sense, can anyone help?

Any help will be appreciated.

Best Regards

Klaus W

I Place this VBA-code in

Private Sub Workbook_Open()

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

End Sub