Option Explicit
Dim scrFso As Object
Dim scrFolder As Object
Dim scrSubFolders As Object
Dim scrFile As Object
Dim scrFiles As Object
Sub OpenAllFilesInFolder()
Dim strStartPath As String
strStartPath = "C:\Afolder"
Application.ScreenUpdating = False
OpenAllFiles strStartPath
SearchSubFolders strStartPath
Application.ScreenUpdating = True
End Sub
Sub SearchSubFolders(strStartPath As String)
If scrFso Is Nothing Then Set scrFso = CreateObject("scripting.filesystemobject")
Set scrFolder = scrFso.getfolder(strStartPath)
Set scrSubFolders = scrFolder.subfolders
For Each scrFolder In scrSubFolders
Set scrFiles = scrFolder.Files
If scrFiles.Count > 0 Then OpenAllFiles scrFolder.Path
SearchSubFolders scrFolder.Path
Next
End Sub
_____________
Sub OpenAllFiles(strPath As String)
Dim strName As String
Dim wdDoc As Document
If scrFso Is Nothing Then Set scrFso = CreateObject("scripting.filesystemobject")
Set scrFolder = scrFso.getfolder(strPath)
For Each scrFile In scrFolder.Files
strName = scrFile.Name
Application.StatusBar = strPath & "\" & strName
If Right(strName, 4) = ".doc" Or Right(strName, 4) = ".dot" Then
Set wdDoc = Documents.Open(FileName:=strPath & "\" & strName, _
ReadOnly:=False, Format:=wdOpenFormatAuto)
DoWork wdDoc
wdDoc.Close wdSaveChanges
End If
Next
Application.StatusBar = False
End Sub
Sub DoWork(wdDoc As Document)
End Sub
|