Option Explicit Const MyFile = "H:\Test.txt" Dim objFso, objTextFile Dim MyArray MyArray = Array("line1","line2","line3") Set objFso = CreateObject("Scripting.FileSystemObject") Set objTextFile = objFso.CreateTextFile(MyFile,True) objTextFile.WriteLine Join(MyArray, vbCrLf) objTextFile.Close Set objTextFile = Nothing Set objFso = Nothing
Option Explicit Const cstFileTablo = "D:\monTest1.txt" Const cstFileTabSum = "D:\monTest2.txt" ReDim arrTablo(1000) ReDim arrTabloSum(1000) Dim sum, i Sum = 0 For i = 1 To 1000 arrTablo(i) = Rnd * 0.5 sum = sum + arrTablo(i) arrTabloSum(i) = sum Next Call WriteTextFile(arrTablo, cstFileTablo) Call WriteTextFile(arrTabloSum, cstFileTabSum) Sub WriteTextFile(ArgArray, ArgFile) 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
Option Explicit Const MyFile = "H:\monTest.vbs" Dim objFso, objTextFile Dim MyArray MyArray = Array("line1","line2","line3") Set objFso = CreateObject("Scripting.FileSystemObject") Set objTextFile = objFso.CreateTextFile(MyFile,True) objTextFile.WriteLine Join(MyArray, vbCrLf) objTextFile.Close Set objTextFile = Nothing Set objFso = Nothing
line1","line2","line3")!
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim TabSum() Dim Tab() For i= 1 to 1000 ' première boucle ReDim Preserve Tab(i) ' Redimensionnement de mon tableau tab(i)= rnd*0.5 sum=0 for j= 1 to UBound(tab) sum= sum+tab(j) next ReDim Preserve tabsum(i) ' Redimensionnement de mon tableau tabsum(i)=sum Next Call WriteTextFile(tabsum) Sub WriteTextFile(tabsum) Const MyFile = "C:\monTest.txt" Dim objFso, objTextFile Set objFso = CreateObject("Scripting.FileSystemObject") Set objTextFile = objFso.CreateTextFile(MyFile,True) objTextFile.WriteLine Join(tabsum, vbCrLf) objTextFile.Close Set objTextFile = Nothing Set objFso = Nothing End Sub
Sub WriteTextFile(tabsum) Const MyFile = "C:\MonFichierEnSortie.csv"
ReDim Preserve tabsum(i)
ReDim Preserve Tab(i)
redim tabsum()! il se redimensionne à chaque nvlle boucle de j aussi!!
objTextFile.WriteLine Join(MyArray, ",")
objTextFile.WriteLine Join(MyArray, ";")
Dim tabloSum(1 To 1000) Dim Tablo(1 To 1000) Sum = 0 For i = 1 To 1000 Tablo(i) = rnd*0.5 Sum = Sum + Tablo(i) tabloSum(i) = Sum Next
'Dim tabloSum(1 To 1000) 'Dim Tablo(1 To 1000) ReDim tabloSum(1000) ReDim Tablo(1000) Sum = 0 For i = 1 To 1000 Tablo(i) = rnd*0.5 Sum = Sum + Tablo(i) tabloSum(i) = Sum Next MsgBox "Tablo : " & Space(1) & Tablo(1) & vbTab & "tabloSum : " & tabloSum(1) &vbCrLf&_ "Tablo : " & Space(1) & Tablo(2) & vbTab & "tabloSum : " & tabloSum(2) &vbCrLf&_ "Tablo : " & Space(1) & Tablo(3) & vbTab & "tabloSum : " & tabloSum(3) _ ,,"UBound Tablo : " & UBound(Tablo) & Space(4) & "UBound tabloSum : " & UBound(tabloSum)
Dim TabSum() Dim Tab() For i= 1 to 1000 ' première boucle ReDim Preserve Tab(i) ' Redimensionnement de mon tableau tab(i)= rnd*0.5 sum=0 for j= 1 to UBound(tab) sum= sum+tab(j) next ReDim Preserve tabsum(i) ' Redimensionnement de mon tableau tabsum(i)=sum Next Call WriteTextFile(tabsum) Sub WriteTextFile(tabsum) Const MyFile = "C:\monTest1.txt" Dim objFso, objTextFile Set objFso = CreateObject("Scripting.FileSystemObject") Set objTextFile = objFso.CreateTextFile(MyFile,True) objTextFile.WriteLine Join(tabsum, vbCrLf) objTextFile.Close Set objTextFile = Nothing Set objFso = Nothing End Sub Call WriteTextFile(tab) Sub WriteTextFile(tab) Const MyFile = "C:\monTest2.txt" Dim objFso, objTextFile Set objFso = CreateObject("Scripting.FileSystemObject") Set objTextFile = objFso.CreateTextFile(MyFile,True) objTextFile.WriteLine Join(tab, vbCrLf) objTextFile.Close Set objTextFile = Nothing Set objFso = Nothing End Sub
Option Explicit Const MyFile = "D:\Tableau.txt" 'Le fichier Tableau contient 'ligne1;comment1;libelle1 'ligne2;comment2;libelle2 'ligne3;comment3;libelle3 Dim objFso, objTextStream, arrLine, liste, imax, i Set objFso = CreateObject("Scripting.FileSystemObject") Set objTextStream = objFso.OpenTextFile(MyFile, 1) Do While Not ObjTextStream.AtEndOfStream arrLine = Split(objTextStream.ReadLine,";") imax = imax + 1 ReDim Preserve Tableau(3, imax) Tableau(1, imax) = arrLine(0) Tableau(2, imax) = arrLine(1) Tableau(3, imax) = arrLine(2) Loop objTextStream.Close Set objTextStream = Nothing Set objFso = Nothing For i = 1 To imax liste = liste & vbCrLf & Tableau(1, i) & vbTab &_ Tableau(2, i) & vbTab & Tableau(3, i) Next MsgBox liste,,"Exemple"