Excel VBA Link Update Problem

Question

I have 2 workbooks, source and linked. The linked workbook contains a link to the source workbook.

I copy this from the VBA help system to the immediate window, I ensure the link workbook is active and the sample code fails.... why?

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSourcesThe issue: i have legacy code with a name like Name:="M:\yadayada\file.xls" that fails.

Answer 1

The help example is incorrect.

The text of the help article is correct but not entirely helpful.

To update all Excel links in the workbook, simplest is just

ActiveWorkbook.UpdateLink Type:=xlExcelLinks

To update a specific link, say the first Excel link source

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources(xlExcelLinks)(1)

Answer 2

headlydotcom,

I tested in excel 2010.   I had a workbook with a link to a closed workbook as the activeworkbook and I ran the code you show in the immediate window and it caused no problem.

I then opened a new workbook with no links and made it the activeworkbook.  Again, no problem.

So I would suggest updating links manually and see if there is a problem. 

--

Regards,

Tom Ogilvy