Workbook links

[AndyMcC]

I have a workbook that is linked to data in another workbook. The filepath for the link at work is M:\66.00 Refit\ (M: is a shared network drive), but if I want to work on the workbook at home the filepath is G:\66.00 Refit\, G: being the EHDD on which I have copied the work files. Obviously I can just change the link source using Edit, Links but is there a way of "automating" this?

 

[tweedle]

Map another Drive "M" equating to the same 'root' path as "G"