Open files in VBA without updating external links

[svjensen]

Using VBA I need to open a number of files, do what ever I need to do (i.e. update a formula) and close it again.

This all works well, but I would like to be able to decide if the workbook I am opening should update external links or not. This should be done without being shown the dialogue box.

The files are opened using:

Workbooks.Open Filename:=arrFiles(i)

I expect that I can add an other argument but am uncertain how.

/Soren

 

[VoG]

Try

Workbooks.Open Filename:=arrFiles(i), updatelinks:=0

 

[svjensen]

That seems to do the trick, thanks.
I assume that if I replace the '0' with '1' then it will automatically update links without prompting?

/Soren

 

[VoG]

From the Help

<table cellpadding="4" cellspacing="4" cols="2"><tbody><tr valign="top"> <th width="20%">Value</th> <th width="80%">Meaning</th></tr> <tr valign="top"> <td class="TT" width="20%">0</td> <td class="TT" width="80%">Doesn't update any references</td></tr> <tr valign="top"> <td class="TT" width="20%">1</td> <td class="TT" width="80%">Updates external references but not remote references</td></tr> <tr valign="top"> <td class="TT" width="20%">2</td> <td class="TT" width="80%">Updates remote references but not external references</td></tr> <tr valign="top"> <td class="TT" width="20%">3</td> <td class="TT" width="80%">Updates both remote and external references</td></tr></tbody></table>

 

[svjensen]

Thanks.
I looked for the difference between 'remote' and 'external' references in Excel help and on the Internet, but did not find an answer.
Anyone who can help with that?

 

[Andrew Poulsom]

A remote reference is a reference to another application (eg Word). An external reference is a reference to another Excel workbook.

 

[svjensen]

Cheers.

Soren