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.
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.