Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open without link update
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update link cells without open up source document files | Excel Worksheet Functions | |||
2003 update link when Source open | Excel Worksheet Functions | |||
How to disable 'Update alert' when open a spreadsheet has link to other XLS | Excel Programming | |||
How to disable 'Update alert' when open a spreadsheet has link to other XLS | Excel Programming | |||
How to disable 'Update alert' when open a spreadsheet has link to other XLS | Excel Programming |