![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
|
||||
|
||||
|
For example:
Code:
Sub GetDocumentStats()
Application.ScreenUpdating = False
Dim strFolder As String, strFile As String, strDocNm As String
Dim strList As String, i As Long, wdDoc As Document
strDocNm = ActiveDocument.FullName: strFolder = "C:\Sam-Documents\VBA-Word"
strFile = Dir(strFolder & "\*.docx", vbNormal)
While strFile <> ""
If strFolder & "\" & strFile <> strDocNm Then
i = i + 1
Set wdDoc = Documents.Open(FileName:=strFolder & "\" & strFile, AddToRecentFiles:=False, Visible:=False)
With wdDoc
With .Range.Find
.Text = strFnd
.MatchCase = False
.MatchAllWordForms = False
.MatchWholeWord = False
.Execute
If .Found = True Then strList = strList & vbCr & strFile
End With
.Close SaveChanges:=False
End With
End If
' Let Word do its housekeeping
DoEvents
strFile = Dir()
Wend
Set wdDoc = Nothing
MsgBox i & " files processed." & vbCr & "Matches with " & strFnd & " found in:" & strList, vbOKOnly
Application.ScreenUpdating = True
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Searching WORD files for specific link ???
|
ksor | Word VBA | 1 | 10-12-2019 08:33 PM |
| Formula for searching names in one go | SilverChat | Excel | 2 | 05-07-2018 06:11 PM |
Using Word VBA to change file names in a directory
|
sg11 | Word VBA | 4 | 03-22-2018 04:25 AM |
Macro to check the existence of a word docx file and create a new word file with specific content.
|
staicumihai | Word VBA | 14 | 11-15-2016 01:42 AM |
How To Apply A VBA Macro to All Subfolders in a Directory of a docx. Extension
|
jc491 | Word VBA | 8 | 09-11-2015 08:31 AM |