Update links when opening workbook without opening source file

[BigDelGooner]

I am using the code below to open a workbook...

Sub OpenGPK()
Workbooks.Open Filename:="\\lon0306\dfs\data\dta\sim_spf\charities team\applications\Gourmet Performance Kitchen.xls"
End Sub

However whilst opening this workbook I would also like to update links to from workbook without opening it, is that possible?

 

[Andrew Poulsom]

The Open method has an UpdateLinks argument, eg:

Workbooks.Open Filename:="\\lon0306\dfs\data\dta\sim_spf\charities team\applications\Gourmet Performance Kitchen.xls", UpdateLinks:=True

 

[BigDelGooner]

Thanks Andrew, but that only seems to work when the source workbook is already open....

 

[Andrew Poulsom]

Please give an example of a link formula that doesn't update.

 

[BigDelGooner]

Hi Andrew, sorry I thought I had got back to you.

I was looking at the wrong source file when checking to see if the 'update links' had worked.

Now I am looking at the correct source file all is in order and the links have updated as expected.

Many thanks for your help