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



I want to import the sheet from the Excel to the Datatable using VB Script. I used the Syntax as..

Answer / 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

More VB Script Interview Questions

what is extension of the file if its saved from recovery manger to some drive

1 Answers  


we executed QTP scripts in one browser(i.e IN)same scripts is working on another browsers or not (i.e mean netscap,m azol..like )

6 Answers   Accenture,


HOW TO OPEN NEW TAB USING VB SCRIPT IN QTP?

1 Answers   TCS,


Anyone have qtp11.0 crack?

0 Answers  


In the Web page we have a table link, if we click on that link all the contents under that link will be sorted (asscending/Descending). Now i want to check in which order the list is ? for that i need to get the data in to some var How can i get that cells data?

1 Answers   Nous,


write a vb script to display 3*3 matrix

1 Answers  


write a program to display the system specifications of client system with the help of vb script.

1 Answers  


how to write validation function for date in vb script

1 Answers  


hi, How will write a regular expression of date in VB scripting.

1 Answers  


Explain the adodb.stream class?

1 Answers  


Why do we use Option Explicit?

6 Answers  


hi i am trying for testing job for 3+ experience(fake) can u suggest me what type of projects i can keep in my resume and how much of knoeledge i should have abt that project.thnks in advance.urgt plz

1 Answers  


Categories