![]() |
#4
|
||||
|
||||
![]()
Given that it's possible for the links to exist in something other than fields, try:
Code:
Sub Update_Links() ' ' Update_Link Macro ' Dim Rng As Range, i As Long, vItem As Variant ' 'Display File Picker Dialog With Application.FileDialog(FileDialogType:=msoFileDialogFilePicker) ' use Show method to dispaly File Picker dialog box and return user's action If .Show = -1 Then 'step throug each string in the FileDialogSelectedItems collection vItem = .SelectedItems(1) Else Exit Sub End If End With ' 'update fields ' Application.ScreenUpdating = False With ActiveDocument For Each Rng In .StoryRanges With Rng For i = .Fields.Count To 1 Step -1 If .Fields(i).Type = wdFieldLink Then .Fields(i).LinkFormat.SourceFullName = vItem Next For i = .ShapeRange.Count To 1 Step -1 If Not .ShapeRange(i).LinkFormat Is Nothing Then .ShapeRange(i).LinkFormat.SourceFullName = vItem Next For i = .InlineShapes.Count To 1 Step -1 If Not InlineShapes(i).LinkFormat Is Nothing Then InlineShapes(i).LinkFormat.SourceFullName = vItem Next End With Next End With ' Application.ScreenUpdating = True MsgBox "Done!" End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
header and footer, link, update |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
kp2009 | Word VBA | 5 | 08-27-2015 11:45 PM |
How can I embed a word document so I don't lose the links therein | Dracven | Outlook | 2 | 03-31-2014 04:02 AM |
Using Quick Parts >> Ref >> Field (Third word changing font) | sonny49 | Word | 1 | 01-07-2014 10:01 AM |
Embedded Links failing in word document | jim_jim | Word | 0 | 02-05-2013 07:48 AM |
Edits links to Excel file in PowerPoint | ziba | PowerPoint | 4 | 01-09-2012 08:48 AM |