Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSub CopieFichier() Dim I As Long, J As Long Dim nbLignes As Long, nbColonnes As Long Dim strTemp As String Dim FF As Integer nbLignes = Cells(Rows.Count, "A").End(xlUp).Row nbColonnes = Cells(1, Columns.Count).End(xlToLeft).Column FF = FreeFile Open "C:\Test.txt" For Output As #FF For I = 2 To nbLignes strTemp = "" For J = 1 To nbColonnes strTemp = strTemp & Cells(I, J) & vbTab Next Print #FF, Left(strTemp, Len(strTemp) - 1) Next Close #FF End Sub