Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim oXL As Excel.Application Dim oXls As Workbook Dim oItem As ListItem Dim oHeader As ColumnHeader Dim oSubItem As ListSubItem Dim nRow As Long Set oXL = New Excel.Application Set oXls = oXL.Workbooks.Add nRow = 1 For Each oHeader In CcLst.ColumnHeaders oXls.ActiveSheet.cells(nRow, oHeader.Index).Value = oHeader.Text Next nRow = nRow + 1 For Each oItem In CcLst.ListItems oXls.ActiveSheet.cells(nRow, 1).Value = oItem.Text For Each oSubItem In oItem.ListSubItems oXls.ActiveSheet.cells(nRow, 1 + oSubItem.Index).Value = oSubItem.Text Next nRow = nRow + 1 Next oXls.SaveAs "c:\export.xls" oXls.Close oXL.Quit