autolink between files

[xj]

Hi, need you helps on automatic links updates between files.
Workbook a.xls contains sheets("b1"), Sheets("c1")
Workbook b.xls contains sheets("b1"), Sheets("b2")
Workbook c.xls contains sheets("c1"), Sheets("c2")

in a.xls, sheets("b1")'s source is sheets("b1") in b.xls. Same with sheets("c1").

These 3 workbooks are in three different networked computers. b.xls and c.xls updates frequently. How can i make a.xls automatically changes with the changes of b.xls and c.xls.

Thx
XJ

 

[Ed Acosta]

You can add a WorkbookBeforeClose Event in workbooks b and c to open workbook a update the data and save it