ExcelBanter - Macro update link

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Macro update link (https://www.excelbanter.com/excel-worksheet-functions/175894-macro-update-link.html)

Macro update link

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

Macro update link

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:="="
--
Gary''s Student - gsnu2007d

" wrote:

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

All times are GMT +1. The time now is 03:15 AM.