pre-determined response within a macro

D

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 ?
 
P

Peo Sjoblom

One way

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