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
| Sub Chargement()
'
' Macro Chargement
'
'
Worksheets("Feuil3").Select
Range("A1").Activate
ChDir "C:\Users\Desktop\"
Workbooks.OpenText Filename:= _
"C:\Users\Desktop\monTexte.txt", _
Origin:=65001, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, _
Comma:=False, Space:=False, Other:=True, OtherChar:="-", 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), Array(9, 1), Array(10, 1), Array(11, 1)), TrailingMinusNumbers:= _
True
Cells.Select
Selection.Copy
Windows("monFichierExcel.xls").Activate
Worksheets("Feuil3").Select
Range("A1").Activate
ActiveSheet.Paste
Application.DisplayAlerts = False
Workbooks("fichierTexte.txt").Close SaveChanges:=False
End Sub |
Partager