Macro update link

[jackcwood]

I need some script that will update work book links even when another
user has the link open.

Any ideas
ActiveWorkbook.UpdateLink Name:= _
"C:\2008.xls", Type:= _
xlExcelLinks

 

[Gary''s Student]

try two things:

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

If this does not work, then try to re-establish all the formulas:

Cells.Replace What:="=", Replacement:="="