Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionFnExcelImportTextFiles "C:\MonDossier", "*.*", "c:\Resultat.csv" Sub ExcelImportTextFiles(ArgPath, ArgFile, ArgFileOutput) Const ForReading = 1 Dim oFso, oFolder, oFileExcel Set oFso = CreateObject("Scripting.FileSystemObject") On Error Resume Next Set oFileExcel = oFso.CreateTextFile(ArgFileOutput, True) If Err.Number <> 0 Then WScript.Echo "Fichier " & ArgFileOutput & " déjà ouvert" : Err.Clear Else Set oFolder = oFso.GetFolder(ArgPath) For Each oFile In oFolder.Files If InStr(1, oFile.Name, CStr(ArgFile)) And oFile.Size <> 0 Then Call oFileExcel.WriteLine(oFso.OpenTextFile(oFolder.Path & "" & oFile.Name, ForReading).ReadAll) End If Next oFileExcel.Close End If Set oFolder = Nothing Set oFso = Nothing Set oFileExcel = Nothing End Sub