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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
Sub stats_questionnaire()
Dim Exp As Explorer
Dim Sel As Selection
Dim Itm As MailItem
Dim lig As Integer
Set Exp = ActiveExplorer
Set Sel = Exp.Selection
lig = 1
reportfilename = "C:\Fichiers\" & "test.xls"
' Ouvre l'application excel'
Set es = CreateObject("Excel.Application")
es.Visible = True
' Ouvre le bon fichier de mise en page
es.Workbooks.Open FileName:=reportfilename
For Each Itm In Sel
While es.Sheets("export").Cells(lig, 1).Value <> ""
lig = lig + 1
Wend
es.Sheets("export").Cells(lig, 1).Value = Itm.UserProperties("identifiant")
es.Sheets("export").Cells(lig, 2).Value = Itm.UserProperties("cai1")
es.Sheets("export").Cells(lig, 3).Value = Itm.UserProperties("cai2")
es.Sheets("export").Cells(lig, 4).Value = Itm.UserProperties("cai3")
es.Sheets("export").Cells(lig, 5).Value = Itm.UserProperties("cai4")
es.Sheets("export").Cells(lig, 6).Value = Itm.UserProperties("cai5")
es.Sheets("export").Cells(lig, 7).Value = Itm.UserProperties("getro1")
es.Sheets("export").Cells(lig, 8).Value = Itm.UserProperties("getro2")
es.Sheets("export").Cells(lig, 9).Value = Itm.UserProperties("getro3")
es.Sheets("export").Cells(lig, 10).Value = Itm.UserProperties("getro4")
es.Sheets("export").Cells(lig, 11).Value = Itm.UserProperties("getro5")
es.Sheets("export").Cells(lig, 12).Value = Itm.UserProperties("commentaire")
lig = lig + 1
Next Itm
es.ActiveWorkbook.Save
es.ActiveWorkbook.Close
Set Itm = Nothing
Set Sel = Nothing
Set Exp = Nothing
End Sub |
Partager