i have .xls,.txt,.doc files are there (together). i want
find only .xls file among them? how can we write function?
Answer Posted / uday kumar_anem
Hi,
Please try with this script:
Set fileSysObj=CreateObject("Scripting.FileSystemObject")
folderPath="D:\"
If fileSysObj.folderexists(folderPath) then
Set fileObj=fileSysObj.getfolder(folderPath)
Set fileObjs=fileObj.files
For Each FileName In fileObjs
If FileName.type="Microsoft Excel Worksheet" then
MsgBox("This is the excel file "&FileName.Name)
End if
next
else
MsgBox("Folder does not exist")
End if
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
I am in .Net development for past 3.5 years and want to enter in to automated testing and learn QTP. For this I need some good tutorial for beginners. I will be really greatful if any one has and they can send it to me on this address- ruchidureja@gmail.com
how to explain a claims and insurance project?
How did you resolve conflicts present in Object Repository?
What is the use of text output value in quicktest professional?
Explain the concept of object repository and how QTP recognizes objects?
banking project description for software tester
Explain the difference between data driven testing and parameterization ?
Why do we use "Text checkpoint" If we can make use of it in "standard checkpoint" ?
What is quick test pro? What is a quick test professional?
Explain in brief about the quicktest professional automation object model?
Explain the concept of how quicktest professional (qtp) identifies object?
Both static and dynamic arrays are handled by the vb script. Is it true?
What test you perform mostly? Regression or retesting in your testing process?
Hi there, I've installed a trial version of QTP to see if it works with my product but I cant automate selecting windows from a tree view? Can anyone give me any pointers? Many Thanks
How will internal and external links be validated and updated? how often?