pre-determined response within a macro

[daniel chen]

I created a macro named - "OpenABC" - to open a workbook.

Sub OpenABC()
Workbooks.Open Filename:="C:\test\ABC.xls"
End Sub

If my workbook "ABC.xls" contains Links, it will prompt to choose <update>
or <don't update>.
Is there a way to enter a pre-determined response within a macro ?

 

[Peo Sjoblom]

One way

Sub OpenABC()
Workbooks.Open Filename:="C:\test\ABC.xls", UpdateLinks:=0
End Sub