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

Which respective symbols are used to separate a line and to break the lengthy statement into multiple statements in the vbscript language?

1369


Mention what is vbscript procedures?

1055


What aspects of vbscript make it safe so that a web page using vbscript cannot destroy or corrupt information on a user's computer?

1159


give me any information abou vb script books learn quckly

2262


What are the differences between sub procedures and function procedures?

1035


What are class variables?

1089


What is the use of the recordset object and which statement is used to create such an object?

1007


hi what is called GUI in QTP 8.2 and how can we test the apllication using GUI?

2401


What are the rules to name variable in vbscript?

1137


How will you check that a variable is an array in vbscript?

1050


What are the 2 ways to pass a value to the function?

1008


How can you fetch the value of a cookie?

1062


Hi Friends my Question is very simple,in Manual testing when we click on a hyper link it directs us to the relavent page or it re-directs us to the current page,so there we can easily write testcase but same thing if we do in automation script using QTP & need to generate report using Reporter.report event how we will do it?thanks in advance...

2154


Which date function is used in the vbscript language to find the difference between the 2 dates?

1110


Which operator is used to perform the comparison among 2 operands in the vbscript language?

1012