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

How do display output message without using msgbox function?

5 Answers  


Explain some uses of vb script?

0 Answers  


how to write basic programs in VB Script like addition, multiplication?

14 Answers  


How are values assigned to the variables in the vbscript language?

0 Answers  


Give me sm ideas to write Vbscripts abt protocol testing abilash700@gmail.com.

0 Answers  






What variable can you use to share info across the whole application for one user?

2 Answers  


write a Vb script to find a whther a selected drive exits.

1 Answers   CTS,


How will you get a string with the specified character the specified number of times in vbscript?

0 Answers  


How to throw an error in vbscript?

0 Answers  


How to get 120 using 5 zeroes, you can use any operator(+, *, /...) in qtp.

2 Answers   Cognizant,


how to retrieve native property value in runtime?

1 Answers   Hexaware,


how to delete folder test3,test4 and test5 using vbscript?

2 Answers  


Categories