1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
Set wObj = CreateObject("Word.Application")
On Error GoTo FinalizeApp
Set Doc = wObj.Documents.Add(Template:= _
Lresult & "Vierge_Ecoute.doc", NewTemplate _
:=False, DocumentType:=0)
For k = 1 To 19
RowQuestion = Sheets("Liste").Range("A" & k).Value
'intitulé de la question
Texte(k) = Sheets("Base").Range("I" & RowQuestion).Value
Texte(k) = Replace(Texte(k), "/", Chr(13))
Texte(k) = Replace(Texte(k), "*", Chr(9))
'Réponse
TexteReponse(k) = Sheets("Base").Range("J" & RowQuestion).Value
TexteReponse(k) = Replace(TexteReponse(k), "/", Chr(13) & Chr(9) & Chr(9) & Chr(9) & Chr(9))
Next k
'Exécuter macro de fichier word
wObj.Run "RenderDoc", RefExam & " " & NumSerie,Texte,TexteReponse
Doc.SaveAs Lresult & RefExam & ".doc"
Doc.Close
... |
Partager