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 36 37 38 39 40 41 42 43 44 45 46
| Sub LectureFichier(CheminNomFichier, QuelNumligne)
Const ForReading = 1
Dim objFSO, Contenu, TblLigne, TblColonne
Set objFSO = CreateObject("Scripting.FileSystemObject")
If objFSO.FileExists(CheminNomFichier) Then
Contenu = objFSO.OpenTextFile(CheminNomFichier, ForReading).ReadAll
Set objFSO = Nothing
TblLigne = Split(Contenu, vbNewLine)
TblColonne = Split(TblLigne(QuelNumligne), "|")
Code = TblColonne(0)
Operator = TblColonne(1)
Number = TblColonne(2)
Amount = TblColonne(3)
NID = TblColonne(4)
leName = TblColonne(5)
laDATE = TblColonne(6)
lHOUR = TblColonne(7)
End If
End Sub
Dim ChemNomFich, Code, Operator, Number, Amount, NID, leName, laDATE, lHOUR,objCDO1
ChemNomFich = "C:\lien\monfichier.txt"
'strFileText = ChemNomFich.ReadAll
'ChemNomFich.Close
arrFileText = Split(ChemNomFich, vbcrLF)
For intArrCounter = 0 to uBound(arrFileText)
objCDO1.Textbody = "See the details of the file "&VbNewLine+vbnewline+vbnewline&""&LectureFichier , arrFileText (intArrCounter)&""&VbNewLine+vbnewline+vbnewline&"valeur de chaque variables" & vbNewLine & _
"Code = " & Code & vbNewLine & _
"Operator = " & Operator & vbNewLine & _
"Number = " & Number & vbNewLine & _
"Amount = " & Amount & vbNewLine & _
"NID = " & NID & vbNewLine & _
"leName = " & leName & vbNewLine & _
"laDATE = " & laDATE & vbNewLine & _
"lHOUR = " & lHOUR _
objCDO1.TO ="adr1@.com"
objCDO1.From = "adr2@.com (CCP Stored Procedure Message)"
objCDO1.Subject = "CCP Stored Procedure"
objCDO1.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objCDO1.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "mysmtp"
objCDO1.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration /smtpserverport") = 25
objCDO1.Configuration.Fields.Update
objCDO1.Send
'LectureFichier ChemNomFich, 2 ' récupération des éléments de la ligne 3
Next |
Partager