auto path for another workbook with VBA in excel

dear all master.
how are u all.

i have a minor problem about link reference in excel. totally, without code vba, i can do it using link reference for access data from another workbook.
now, problem i found when i moved a workbook and all link reference not work expect i will re insert link reference.

how i can do with vba code for access another workbook without setting manual the link reference?
what is program vba run automate update data when one of workbook is open?(example: workbook1 will get source from workbook2 and connection is using link reference)
hope u can help me..

thx