Facebook

Course Name Start Date Time Duration Registration Link
No Training Programs Scheduled ClickHere to Contact
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