Using Excel's UpdateLink() method from VBScript

Question

I want to update all the links in a certain Excel file and I put the code on a VBScript. What is wrong with the following code?

file = Directory2 & Filename2
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open(file)
objExcel.Application.Visible = True
objExcel.ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources 
objExcel.ActiveWorkbook.Save 
objExcel.ActiveWorkbook.Close

This returns:

Error code: 800A0400

Bond · Accepted Answer · 2015-07-24 14:42:49Z

4

VBScript doesn't support named parameters (Name:=ActiveWorkbook.LinkSources)

Name is the first argument to UpdateLink(), however, so just pass the value:

objWorkbook.UpdateLink objWorkbook.LinkSources

You were also using ActiveWorkbook without qualifying it. You need to use either:

objExcel.ActiveWorkbook.LinkSources

or

objWorkbook.LinkSources

answered Jul 24, 2015 at 14:42

Bond

16.3k6 gold badges34 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using Excel's UpdateLink() method from VBScript

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related