Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

I want to import the sheet from the Excel to the Datatable
using VB Script. I used the Syntax
as 'Datatable.ImportSheet "Filename","SourceSheet","Destinat
ionSheet"
Ex:
Datatable.ImportSheet "D:\Data1.xls","Sheet1","Global"
Qtp producing run time error,How I can solve the problem

Answer Posted / swayam.nayak

Instead of writing Datatable.ImportSheet "D:Data1.xls","Sheet1","Global" this

Try to put this code

"D:Data1.xls","Sheet1","1"

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what types of bugs will we find out in banking projects for automation testing?

2186


how to acces the remote mechine using vb cript(QTP)

1994


Explain about operator precedence in vb script?

1029


How to get the length of the string by making use of the string function?

1026


how to write codings in QTP using vb script. please help me. i am new to QTP. it is easy or very much tough. please tell me

14091


Why is it recommended to close the database connection every time after the work is completed?

894


What are the different types of operators and their order of precedence?

1006


How to access array data?

961


How are values assigned to string type and numeric type variables?

956


What is the use of option explicit statement?

962


write a program to display configuration of a local system with the help of vb script.

2077


Which conditional statement is the most convenient one to use in the case of multiple conditions in the vbscript language?

931


Explain about arrays in vb script?

1030


What are the environments supported by vbscript language?

892


Can any one provide code for Mid(string,start[,length]). I have been asked to write code for Mid(). i.e We need to define our own function say MyMid() which should behave same like built-in Mid function

2392