Update Links
I have a macro that opens an excel file. Before
proceeding with the rest of the code, the "update Links"
message box appears. What code can I write to
answer "yes, update links"?
The start of the current code is:
Workbooks.Open FileName:= _
"\\GRUMPY\LOCALITY CONFIRM\MasterLGConfirm.xls"
Range("A1").Select
ActiveCell.FormulaR1C1 = "'071"
Sheets("survey").Select
Range("A1:k100").Select
Thank you for your help.
|