![]() |
|
#1
|
|||
|
|||
|
Hi, i have different Word documents in a folder, which i merge using this code. Code:
Sub MergeDocs()
Dim rng As Range
Dim MainDoc As Document
Dim strFile As String
Const strFolder = "C:\Book\Chapters\" 'change to suit
Set MainDoc = Documents.Add
strFile = Dir$(strFolder & "*.doc") ' can change to .docx
Do Until strFile = ""
Set rng = MainDoc.Range
rng.Collapse wdCollapseEnd
rng.InsertFile strFolder & strFile
strFile = Dir$()
Loop
End Sub
Is it possible to add some code so that when merging, the links are updated thanks |
|
#2
|
||||
|
||||
|
Merging documents should not affect any existing links to Excel files, so it's not apparent what your issue is.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Merging data from Two word documents based on number search
|
PRA007 | Word Tables | 6 | 11-23-2015 05:30 AM |
Merging Word docs / PDFs while keeping external links
|
Daedalus | Word | 1 | 05-11-2015 07:37 AM |
| Word updating Excel links automatically | Bob Loblaw | Word | 0 | 02-11-2015 06:26 AM |
Merging bibliographies with word documents using separate master lists
|
Cimballi | Word | 3 | 07-01-2014 03:45 AM |
| How to preserve or Retain bookmarks during Merging of word documents | ramsgarla | Word | 2 | 09-18-2012 08:59 AM |