Facebook

Course Name Start Date Time Duration Registration Link
Cypress JavaScript API Testing 2nd October 2021 9AM - 2PM IST 3 Weekends (30Hours) ClickHere to Register
Please mail To sudhakar@qtpsudhakar.com to Register for any training

Monday, July 6, 2009

Read CSV File Data

'******************************************************
Dim file,fso,f,fData,arrData,CsvValue
file="C:\sample.csv"
 
Set fso=createobject("scripting.filesystemobject")
Set f  = fso.OpenTextFile(file)
 
While not f.AtEndOfStream
fData=f.ReadLine
arrData=split(fData,",")
For Each CsvValue In arrData
MsgBox CsvValue
Next
Wend
f.Close
Set fso=Nothing
'******************************************************

No comments :

Post a Comment