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
|
Sub Macro3()
Dim FolderName As String, FName As String
Dim Wbk As Workbook
Application.ScreenUpdating = False
FolderName = "C:\Users\SONY\Desktop\Dossier\" 'le remplacement de tout les ";" par les "," se fait au niveau de chaque fichier du repertoire nommé Dossier
FName = Dir(FolderName & "*.csv")
Do While Len(FName)
Set Wbk = Workbooks.Open(FolderName & FName)
With Wbk
With .Worksheets(1)
Cells.Replace What:=";", Replacement:=",", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False 'remplacer tout ";" par ",
End With
Application.DisplayAlerts = False
.SaveAs Replace(.FullName, ".csv", ".xls"), xlWorkbookNormal
Application.DisplayAlerts = True
.Close False
End With
Set Wbk = Nothing
FName = Dir
Loop
End Sub |
Partager