Answer / shobhit kaul

hi frnds in the above answer(by king) there is only one
change

as inspite of creating object of quicktest.applicaton
you should create object of wscript.shell
The code is as::

Set app=CreateObject("Wscript.shell")
SystemUtil.run("cmd.exe")
app.sendkeys "cd\"
app.sendkeys "~" 'its for enter key
app.sendkeys "default.xls" 'this xls should be any where
your c drive

app.sendkeys "~"



Please correct me if i am wrong any where
my emai id is
kaul.shobhit@gmail.com

Answer / mahi

using "Wscript.Shell" object we can work on command prompt
in qtp.

'create one instance for "wscript.Shell"
set oShell=CreateObject("Wscript.Shell")
'using run method we can invoke application
'/k this will display command prompt.we can also use /c but
we can not see command prompt.It will disappear after
executeion.
oShell.Run "cmd /k dir"
'if we want use multiple commands we can use "&"(amp) symbol
oShell.run "cmd /k dir & md qtp"
set oShell=Nothing

I hope it will useful.
Regards,
Mahi.kotike@gmail.com

Answer / king

Set =createobject("wscipt.shell")
a.run "cmd /K CD C:\ & Dir"

Answer / r.prasad

hi ,
u can open command prompt using following script also



dim app
set app=createobject("QuickTest.application")
SystemUtil.run "cmd.exe"

Answer / king

Hi Bathi,

dim app
set app=createobject("QuickTest.application")
SystemUtil.run "cmd.exe" 'the command prompt open
app.sendkeys "cd\"
app.sendkeys "~"
app.sendkeys "cd Foldername"
app.sendkeys "~"
app.sendkeys "dir *.xls"
app.sendkeys "~"

i think this is working properly accoring to my knowledge.

Answer / sandeep

To know ALL .XLS FILES in the folder. Please use file
system object.

Create file system object.

Check using fileExists method.

You can also make array of .xls file and return the array.

Answer / bathi

Hi King,

Thanks 4 the ans.

I want have still more clarification abt this. suppose I
want to know list all excel sheet present in some folder
using console. how can i do that?

Answer / ravi_kanakam

Hi King

app.sendkeys showing error..

in which situation u will use recording and in which situation u will used to write script manually

1 Answers  

RECENTLY I PLACED IN QTP..HOW TO IMPROVE VB SCRIPTS KNOWLEDGE? IAM STRUGGING TO WRITE THE AUTOMATION SCRIPTS? ANY BODY TELL HOW TO IMPROVE QTP SCRIPT SKILLS?

0 Answers  

Hi All, we are using QTP Automation Scripts to test SAP. I recorded QTP Automation Scripts in English-based SAP GUI. Now we have to test a French-based SAP sytem and use the same scripts. The QTP scripts are failing when executed on the French-based SAP System due to Object Recognition Issues. What can we do? Do I re-record the scripts in the French-based SAP system?

0 Answers  

how i will connect oracle or microsoft acess database through manually written Script

2 Answers   Aurigo,

How can I import environment from a file on disk?

0 Answers  

What is method name to compare two XML files.

0 Answers  

How do you test siebel application using qtp?

2 Answers  

what type of scripts are asked in qtp?

2 Answers  

Give answer with example what is orthogonal array testing technique?

1 Answers   CTS, Wipro,

What is clean sweep?

0 Answers  

how to use command prompt using qtp?

8 Answers   HCL,

hi, for QTP TRAINING......SURESH REDDY SMART SOLUTIONS sr.nagar IS BEST OR NOT? how faculty teaches?

4 Answers   Cap Gemini,