How to write a macro that that will re-link an excel file

Hi Everyone,

Is there a way for me to write a macro that will automatically re-link (like clicking edit link under data tab) into another file.

lets say file Y.xls is linked to xmmddyy.xls and everyday I save a new xmmddyy.xls.

Is there a way for me to create a macro that will relink y.xls to the latest xmmddyy.xls? I'm thinking if i can write the edit link in macro and just use the today function somewhere....What do you guys think?


Thanks!
Carlos

One approach would be to create a Defined Name called "ExtLink" as the external workbook name (e.g. "X072217.xls").
Then, for example, when you make a reference to the external workbook, use =INDIRECT("'[" & ExtLink & "]Sheet1'!A1")

Add a simple macro to update:

Please Login or Register  to view this content.

Thanks for the help bro!