Statement not to update the file while opening through Macro

[Gautam]

I am opening various workbooks one after the other inorder to get some
information in it, through a macro. Now everytime the workbook is
opened, it asks for updating of links and stops there. I need a
statement which automatically replys the excel not to update the
files, in the existing macro.

Thanks

 

[Norman Jones]

Hi Gautam,

Look as the UpdateLinks argument to the Workbook
Open method.

Try something like:

'=============>>
Public Sub Tester()
Dim WB As Workbook

Set WB = Workbooks.Open(Filename:="ABC.xls", _
UpdateLinks:=0)
End Sub
'<<=============