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
| Sub ExportDesDonneesXML()
Dim Chemin As String, Nom As String, Fichier As String
Dim Ws As Worksheet
Dim N As Integer
Chemin = ThisWorkbook.Path & "\" '"DD MAC:Users:daniel:Desktop:XML:COM-2013:janvier:"
Nom = ThisWorkbook.Name
Fichier = Chemin & Left(Nom, InStrRev(Nom, ".")) & "xml"
N = FreeFile
Open Fichier For Output As #N
For Each Ws In ThisWorkbook.Worksheets
ExportFeuille Ws, N
Next Ws
Close #N
End Sub
Private Sub ExportFeuille(ByVal Ws As Worksheet, ByVal N As Integer)
Dim LeMois As String
Dim i As Long
With Ws
LeMois = LCase(Ws.Name)
Print #N, "<" & LeMois & ">"
i = 9
Do While .Cells(i, 1).Value <> ""
Print #N, "<previsions>"
Print #N, "<contact>" & .Cells(i, 1) & "</contact>"
Print #N, "<confirme>" & .Cells(i, 2) & "</confirme>"
Print #N, "<nom>" & .Cells(i, 3) & "</nom>"
Print #N, "<format>" & .Cells(i, 4) & "</format>"
Print #N, "<pages>" & .Cells(i, 5) & "</pages>"
Print #N, "<quantites>" & .Cells(i, 6) & "</quantites>"
Print #N, "<fichiers>" & .Cells(i, 7) & "</fichiers>"
Print #N, "<livraison>" & .Cells(i, 8) & "</livraison>"
Print #N, "<service>" & .Cells(i, 9) & "</service>"
Print #N, "<imprimerie>" & .Cells(i, 10) & "</imprimerie>"
Print #N, "</previsions>"
i = i + 1
Loop
Print #N, "</" & LeMois & ">"
End With
End Sub |
Partager