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
| Sub Daniel_ExportDossierCSV()
Dim Enrgt As String, FSO As Object, F As Object, Dossier As String
Dim Repertoire As FileDialog, Sh As Worksheet, Wbk As Workbook
Set FSO = CreateObject("Scripting.FileSystemObject")
Set Repertoire = Application.FileDialog(msoFileDialogFolderPicker)
Repertoire.Show
For Each F In FSO.getfolder(Repertoire.SelectedItems(1)).Files
Dossier = Repertoire.SelectedItems(1)
If LCase(Right(F.Name, 4)) = ".xls" Then
Set Wbk = Workbooks.Open(F.Path)
For i = 1 To Wbk.Worksheets.Count
Set Sh = Wbk.Worksheets(i)
Debug.Print Dossier & "\" & F.Name & "-" & Sh.Name & ".csv"
If Application.CountA(Sh.Cells) > 0 Then
Close #1
Open Dossier & "\" & F.Name & "-" & Sh.Name & ".csv" For Output As #1
For Each c In Sh.Range(Sh.Cells(1, 1), Sh.Cells(Rows.Count, 1).End(xlUp))
Enrgt = ""
For Each x In Sh.Range(Sh.Cells(c.Row, 1), Sh.Cells(c.Row, Columns.Count).End(xlToLeft))
Enrgt = Enrgt & """;""" & x.Value
Next x
Enrgt = Right(Enrgt, Len(Enrgt) - 2) & """"
Print #1, Enrgt
Next c
Close #1
End If
Next i
Wbk.Close , False
End If
Next F
End Sub |
Partager