Set ObjWord = CreateObject("Word.Application")
ObjWord.Visible = False
Set docMultiple = ObjWord.Documents.Open(LbNomeFile.Caption)
On Error GoTo 0
With ActiveDocument.Content.Find
Do While .Execute(FindText:="FINE DOCUMENTO", Forward:=True, MatchCase:=True) = True
NumAz = NumAz + 1
Loop
End With
For i = 1 To NumAz
Z = DoEvents()
PartitaIVA = ""
With Selection.Find
.Text = "FINE DOCUMENTO"
.Forward = False
.Execute
.Text = ""
End With
Selection.Extend
With Selection.Find
.Text = "FINE DOCUMENTO"
.Forward = True
.Wrap = wdFindStop
.Execute
.Text = ""
End With
Selection.Copy
Documents.Add
Selection.Paste
Call Del_All_SB
'--- elimino il FINE DOCUMENTO
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = "FINE DOCUMENTO"
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
End With
Selection.Find.Execute Replace:=wdReplaceAll
'---
FileTemp = CartellaRendicontiAziende & "\" & CStr(i) & ".doc"
ActiveDocument.SaveAs FileName:=FileTemp
'--- devo leggere la partita iva
For sentenceCount = 1 To ActiveDocument.Sentences.Count
Riga = ActiveDocument.Sentences(sentenceCount)
Z = DoEvents()
If InStr(Riga, "XYZKJ") > 0 Then
ele = Split(Riga, "|")
PartitaIVA = ele(3)
Criterio = "SELECT RagioneSociale,PartitaIVA FROM TabAziende WHERE PartitaIVA='" & PartitaIVA & "'"
Debug.Print Criterio
With rs
.CursorLocation = adUseClient
.Source = Criterio
.Open , cnn, adOpenDynamic, adLockOptimistic, Options:=adCmdText
End With
If Not rs.EOF Then
ActiveDocument.Close
RagioneSociale = rs(0)
FileDefinitivo = CartellaRendicontiAziende & "\" & PartitaIVA & "_" & Format$(Now, "DD-MM-YYYY") & ".doc"
If Dir$(FileDefinitivo) <> "" Then Kill FileDefinitivo
FileCopy FileTemp, FileDefinitivo
Kill FileTemp
List1.AddItem RagioneSociale & " --> " & PartitaIVA & "_" & Format$(Now, "DD-MM-YYYY") & ".doc"
Debug.Print RagioneSociale, PartitaIVA
Else
ActiveDocument.Close
List1.AddItem PartitaIVA & " NON TROVATA"
End If
rs.Close
Exit For
End If
Next
Next i