ChDir "c:\test1"
Workbooks.OpenText Filename:= _
"c:\test1\DASHBM.txt", Origin:=437, StartRow:= _
1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=True, Comma:=False, _
Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), Array( _
3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1)), _
TrailingMinusNumbers:=True
ActiveWorkbook.SaveAs "DASHBM.xls" ' ou Nom donné en C9
With Worksheets("DASHBM")
For y = 2 To 4
For x = 3 To 8
.Cells(y, x).Value = Val(.Cells(y, x))
Next
Next
Columns("D:H").Select
Selection.Style = "Comma"
Selection.NumberFormat = "#,##0.00"
Columns("D:H").EntireColumn.AutoFit
End With
End Sub