**VBA** Refresh data linked / connected to another workbook via shared network drive

[Aton999]

Hi,

My workbook relies on values from other 5 workbooks saved on a network drive. The issue is that when someone tries to use the same workbook, they will need to go an update each link as the mapping drive letter varies between us. Therefore, I would like to add the ability to replace drive letters in the "Edit Links" dynamically.

I wonder if there is a VBA code to help please?

Thanks, aton

 

[Aton999]

Any help is much appreciated.

Thanks, aton