ExcelBanter - Update Links

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Update Links (https://www.excelbanter.com/excel-programming/303479-update-links.html)

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.

Click on .Open in your code and hit F1.

You'll see that this command has an Updatelinks option that you can specify.

Kimberly wrote:

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.

--

Dave Peterson