Vba updating links

Any ideas on how to solve the issue are appreciated.

Background: I have a Excel spreadsheet feeding a word document with data.

There are several ways this problem can be approached.

First, you can configure Excel so that it doesn't ask the question.

Edit I have provided 2 sample files as a MWE of the issue. , I created a VBA script to name all the ranges linked.

So instead of changing the link item in Word, I change the named range value in excel.

vba updating links-64vba updating links-55

Q): I do not want updation of links automatically whenever there is any change in the source file.

Display Alerts = False Workbooks(Right(Full Name, Len(WBFile Name(x, 1)) - In Str Rev(WBFile Name(x, 1), "\"))).

Close Next x End Sub I didn’t have time to test, but this should fit the bill.

Let me know if you have any errors that you can’t figure out.

Bill Buker VBA Developer" id="ctl00_m_m_i_ctl00_gr_ctl01_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="2006104" / Hi Katy, Since there is no way to include a password using Update Link. Try this, in the workbook whos links you want to silently update go to the Thisworkbook module and create a Workbook_Open Stub Private Sub Workbook_Open() ' Change the 4 in "WBFile Name(1 To 4, 1 To 2)" to ' what ever # of files you have, ' The "1 to 2" should stay unchanged.

Leave a Reply