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

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?

hi ,
u can open command prompt using following script also



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

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.

Hi King

app.sendkeys showing error..

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

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.