Dépose un bout de fichier...
Sub ab()
Dim oFSO
Dim oFS
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oFS = oFSO.OpenTextFile("c:\temp\test.txt")
Do Until oFS.AtEndOfStream
i = i + 1
Cells(i, 1) = oFS.ReadLine
Loop
End Sub
= Application.GetOpenFilename("Fichier Texte,*.txt")
= Application.GetOpenFilename("TEXT")