Updating link macro

[moyemrick]

I'm trying to create a macro that update the links (or one specific one) on my worksheet. Does anyonre know how to do this?

thanks,

moy

 

[xenou]

Assuming you do not mean hyperlinks....

http://www.mrexcel.com/board2/viewtopic.php?t=276872&highlight=links

Or
"Find links in a workbook" in the Excel help files. You do a find and replace operation (Ctrl + H)

Regards.

------
EDIT:
I should be more clear:
If your formulas look like -
=[BookOne.xls]Sheet1!$A$1

You can Find -
BookOne.xls

and Replace -
BookNewBook.xls

I guess I am thinking in terms of updating as changing.

------
If you mean updating links as refreshing the values:

Sub MyUpdateLinks()

ThisWorkbook.UpdateLink Name:=ThisWorkbook.LinkSources

End Sub

The above code is from the help files and is supposed to update all link sources...I haven't tested it. I changed the reference from ActiveWorkbook (in the help files) to ThisWorkbook (in my code above).

Hope I have got this right for you! I suppose alternatively you could just open the link sources.