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 Procedure or Subroutine in VB Script?

0 Answers  


What is vbscript?

0 Answers  


Hi Friends Rajendra this is bhavani prasad, iam working Hyderabad. i faced one problem with qtp recording mode i.e in my application there is 100 records first we click the first record that record will be jumped to next session and 99 records will there stop the recording and run the same script .Run this script qtp does not identify the records. So plz tell me what is the solution.

0 Answers  


When does ‘on click of button’ event gets triggered in the vbscript language?

0 Answers  


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

0 Answers  


Can any 1 modify the code whr in want to add\rename a excel sheet in qtp?

1 Answers  


Write a program using Java Script / VBscipt that checks if two matrices have identical values in all the elements

1 Answers   Ignou,


Whenever I use Wscript.Echo Qtp raising Run time error as 'Object required for Wscript' How I can create object for Wscript

1 Answers  


How many data types are supported in Vbscript?

3 Answers   Microsoft,


Why is the use of exit do or exit for statements within loops discouraged?

0 Answers  


Write a VB Script to count blank Lines in a notepad

2 Answers   IBM,


Find Out Length of an array without using Ubound?

1 Answers  


Categories