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
|
Option Explicit
Sub LectureTxt()
Dim Fichier As Variant
ChDir ThisWorkbook.Path
Fichier = Application.GetOpenFilename("Fichier TXT (*.txt), *.txt")
If Fichier <> False Then LireFSO Fichier
End Sub
Private Sub LireFSO(ByVal sNomFichier As String)
Dim s As String, sTmp As String
Dim FSO As Object
Dim Fichier As Object
Dim iRow As Long, iCol As Long
Dim Ar() As String
Dim i As Long
Const Separateur As String * 1 = " "
ShTst.Cells.Clear
Application.ScreenUpdating = False
Set FSO = CreateObject("Scripting.FileSystemObject")
Set Fichier = FSO.GetFile(sNomFichier).OpenAsTextStream
iRow = 0
Do While Not Fichier.AtEndOfStream
iCol = 1: iRow = iRow + 1: sTmp = ""
s = Fichier.ReadLine
Ar = Split(s, Separateur)
ShTst.Cells(iRow, iCol) = Ar(LBound(Ar))
For i = LBound(Ar) + 1 To UBound(Ar)
sTmp = Ar(i) & Separateur & sTmp
Next i
iCol = iCol + 1
ShTst.Cells(iRow, iCol) = sTmp
Loop
Fichier.Close
Set Fichier = Nothing
Set FSO = Nothing
Application.ScreenUpdating = True
End Sub |
Partager