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