re-bonjour
Reprise de ton script
Option Explicit
Dim strFileTablo, strFileTabSum
ReDim arrTablo(1000), arrTabloSum(1000)
Dim sum, i
strFileTablo = "C:" & Year(Date) & Mid(Date, 4,2) & Left(Date,2) & _
Replace(Time,Chr(58), vbNullString) & ".txt"
strFileTabSum = "C:" & Year(Date) & Mid(Date, 4,2) & Left(Date,2) & _
Replace(Time,Chr(58), vbNullString)+1 & ".txt"
Sum = 0
For i = 1 To 1000
arrTablo(i) = Rnd * 0.5
sum = sum + arrTablo(i)
arrTabloSum(i) = sum
Next
Call WriteTextFile(strFileTablo,arrTablo)
Call WriteTextFile(strFileTabSum,arrTabloSum)
Sub WriteTextFile(ArgFile, ArgArray)
Dim objFso, objTextFile
Dim j
Set objFso = CreateObject("Scripting.FileSystemObject")
Set objTextFile = objFso.CreateTextFile(ArgFile,True)
For j = 1 To UBound(ArgArray)
objTextFile.WriteLine ArgArray(j)
Next
objTextFile.Close
Set objTextFile = Nothing
Set objFso = Nothing
End Sub
jean-marc