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 39 40 41 42 43 44 45 46
| Sub copie_colle_TXT()
'
Dim chemin As String
Dim i As Integer
i = 1
nb = Sheets("Feuil1").Cells(1, 12)
MsgBox nb
For i = 1 To nb
chemin = Sheets("Feuil1").Cells(i, 1)
Workbooks.OpenText Filename:= _
"V:\_Dossiers personnels\Cédric\Controle billets\2020\FRANCE BILLET\Fichiers_Ventes_2020\" & chemin & ".mjb", Origin:= _
xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, _
Comma:=False, Space:=False, Other:=False, FieldInfo:=Array(1, 1), _
TrailingMinusNumbers:=True
'Supprimer les lignes vides
'Columns(1).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
'Selectionner toutes les cellules pleines
Dim MaPlage As Range
Set MaPlage = Range("A1:A" & Range("A1").End(xlDown).Row)
MaPlage.Select
'Range("A1:A65000").Select
Selection.Copy
Windows("Analyse_FRANCE BILLET_2020_v1.xlsm").Activate
ActiveSheet.Paste
'vider le presse papier
Application.CutCopyMode = False
'Selectionner la première ligne vide
Range("A65536").End(xlUp).Offset(1).Select
Windows(chemin & ".mjb").Activate
ActiveWindow.Close SaveChanges:=False
Next
End Sub |
Partager