Macro update link

  • Thread starter Thread starter jackcwood
  • Start date Start date
J

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
 
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:="="
 
Back
Top