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
|
Sub LireFichierTexte(ByVal Fichier As String)
'------------------------ajouter la reference MICROSOFT SCRIPTING RUNTIME------------------------------------------------------
' [Developpeur][Outils][Réferences]
Dim oFSO As Scripting.FileSystemObject
Dim oFl As Scripting.File
Dim oTxt As Scripting.TextStream
Dim i As Integer
Dim CheminComplet As String ' Filename est un nom réservé, il ne faut pas l'utiliser.
Dim MaChaine As String
CheminComplet = Environ("HOMEPATH") & "\Documents\" & Fichier
Set oFSO = New Scripting.FileSystemObject
Set oFl = oFSO.GetFile(CheminComplet)
Set oTxt = oFl.OpenAsTextStream(ForReading)
'Lire
While Not oTxt.AtEndOfStream
i = i + 1
Range("A" & i) = oTxt.readline ', 2, Len(oTxt.readline) - 2)
'convertir en colonne
MaChaine = Mid(Range("A" & i), 2, Len(Range("A" & i)) - 4)
Range("A" & i) = MaChaine
Application.DisplayAlerts = False
Range("A" & i).TextToColumns , DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Comma:=True, Other:=False, FieldInfo _
:=Array(Array(1, 1)), TrailingMinusNumbers:=True
Application.DisplayAlerts = True
' ExtraireLesChampsDeLaColonneC Range("C" & i) ' Supprimer la cote ' pour extraire les champs contenus dans la colonne C
Wend
Set oFSO = Nothing
Set oFl = Nothing
Set oTxt = Nothing
End Sub |
Partager