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
'<<=============


---
Regards,
Norman



"Gautam" wrote in message
oups.com...
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