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?

2165


Write a Program to add 2 numbers without using operators (+,-) and without using third variable. Note: Use VBScript only Hint: You can use other operators like '/' & '*'(Division & Multiplication)

3611


How can you destroy an object in vbscript?

1052


What are the differences between sub procedures and function procedures?

928


When to use function procedures and what are its characteristics?

1027


Explain vbscript in detail?

1006


Explain about scrrun.dll?

894


Hello friends..... Can any give the methods for Ms-Access, and Mozilla firefox in Automation Object Model in QTP. Please give me currect answers... if you do not understand my question please don't give answers. Thanking you.

2286


How do i automate a website www.flyashx.com without having any test cases witin a week time.

1844


How many types of procedures are available in the vbscript language?

943


Mention what is the use of option explicit in vbscript?

917


what is resorceallocation

2150


Write a vbscript procedure that converts feet to inches. Hint: there are 12 inches in a foot?

981


How to capture a runtime error in vbscript?

1084


Explain about arrays in vb script?

1012