Interested to Buy Any Domain ? << Click Here >> for more details...
i have .xls,.txt,.doc files are there (together). i want
find only .xls file among them? how can we write function?
- 3 Answers
- 8040 Views
- CTS, I also Faced
- E-Mail Answers
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 opened gmail login into gmail and i have to save (Pass or move) all the mail into notepad please give me code Thanks of all
Diff b/w test scenario's and test Procedures?
tell me exact differenceb bw qtp and selenium?(could not tell open soure and licennce? difference in usage and technical difference?
In qtp, how you can use xpath to identify objects?
How to handle the exceptions using recovery secnario manager in quicktest professional (qtp)?
What is a Patch in QTP?
If you have two monitors one is of 19inch and the 2nd one is of 24inch,if you want to write same QTP script in both the two monitors is there any changes required in the script?
how can i sent QTP results to the Html, notefile ,xl file give me the code using g mail login page
I would like to directly import XL file and work on that XL file directly in QTp script in that XL sheet need to allocate workbench,XL sheet and generate two bar graphs automatically how to do that? plz let me know any answers?
what function you write to do database testing with the help of qtp?
What is object repository in qtp?
What is the file extension of the code file and object repository file in QTP?
What is the registration process and examination fees?
Can an action have 2 shared object repositories associated with them? In that case, if two of them contain the same object, which one will be considered?
If you are testing a web application then what will you test in that application?
