I have produced a procedure that opens up a external worksheet, searchs
for a value and then returns to original sheet and pastes, this is in a
loop and continues until it runs out of things to find.

My problem is i would only like to open the excel file once and see the
message box that asks whether you want to update links once. At present
it is asking me on every loop.

I have been using this within my loop
Set bk2 = Workbooks.Open(filepath2)

Ive also tried to use this statement before loop starts and then try
bk2.activate
but this still brings up the message box and asks to update links.

How can i either suppress this message or just update file at the start
of the loop and avoid being asked again? thanks


--
cereldine
------------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=531884