Facebook

Course Name Start Date Time Duration Registration Link
QTP/UFT Weekend Training 26th June 2021 9AM - 2PM IST 4 weekends 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