--
Hi Paul,

Set the UpddateLinks property of the Open method to True, e,g,:

Workbooks.Open "Book1.xls", UpdateLinks:=True


---
Regards,
Norman



"PaulOakley" wrote
in message ...

Could somebody please tell me what code i need to write into a macro to
remove the pop up box asking you to update links when opening a file???
I want this to be automated and not for my end user to have to click the
update button.

Thanks in advance, enjoy your weekends, thank goodness it is friday!!!


--
PaulOakley
------------------------------------------------------------------------
PaulOakley's Profile:
http://www.excelforum.com/member.php...o&userid=25103
View this thread: http://www.excelforum.com/showthread...hreadid=391227