Statement not to update the file while opening through Macro
 

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

Statement not to update the file while opening through Macro
 

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