Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Links
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Update links | Excel Discussion (Misc queries) | |||
How do you update links | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |