Automatically click "Update Links" & "Continue"
 

I have a macro that opens many new workbooks and pulls data from them.
However, after the first workbook is opened, I am asked to update the
links. After clicking "update links" I then receive another message
box saying some links could not be updated and I then click "Continue".
The macro runs fine after this. I would like the macro to
automatically make these selections. Can anyone send me a link to some
resources that may assist me?

Thanks,
Paul


--
paulharvey
------------------------------------------------------------------------
paulharvey's Profile: http://www.excelforum.com/member.php...o&userid=25227
View this thread: http://www.excelforum.com/showthread...hreadid=548134