1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| Sub FilesEOggettiByGAB_53() ' di gab_53 di manuali.net - estrae la riga oggetto da tutti i doc
Dim f As String, miadir As String, i As Integer
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim tString As String, tRange As Word.Range
Dim p As Long
i = 10
miadir = Range("a1").Value
f = Dir(miadir & "*.doc")
If f = "" Then Exit Sub
While f <> ""
i = i + 1
Cells(i, 1) = f
Set wrdApp = CreateObject("Word.Application")
Set wrdDoc = wrdApp.Documents.Open(miadir & f)
With wrdDoc
For p = 1 To .Paragraphs.Count
Set tRange = .Range(Start:=.Paragraphs(p).Range.Start, _
End:=.Paragraphs(p).Range.End)
tString = tRange.Text
tString = Left(tString, Len(tString) - 1)
If Left(tString, 7) = "Oggetto" Then
ActiveSheet.Range("B" & i).Formula = Mid(tString, 10, 150)
Exit For
End If
Next p
End With
wrdApp.Quit
Set wrdDoc = Nothing
Set wrdApp = Nothing
f = Dir
Wend
End Sub |
Partager