Mega Code Archive
Values for the UpdateLinks Argument
<![CDATA[
Value Effect
(omitted) Excel prompts the user to decide how to update links.
0 Excel doesn't update links.
1 Excel updates external links but not remote links.
2 Excel updates remote links but not external links.
3 Excel updates all links.
Sub open()
Workbooks.Open Filename:= "C:\Business\Expenses.xls", UpdateLinks:=0
End Sub
]]>