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



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 the difference between for loop and while loop?

0 Answers  


How can you destroy an object in vbscript?

0 Answers  


Explain the functionality of vbscript?

0 Answers  


What is the difference between javascript and vbscript?

0 Answers  


When inserting strings into a SQL table in ASP what is the risk and how can you prevent it?

1 Answers  


write a vb script to find simple interest using functions

1 Answers  


why do u choose to go for testing why cant for devoloping

0 Answers  


What is the purpose of drive object of scripting.filesystemobject class in vbscript?

0 Answers  


How to use QTP Object in .vbs(vbscript file) file Ex: Browser().., wait(), exist() and etc...

0 Answers  


Which operator is used to concatenate the 2 values in the vbscript language?

0 Answers  


What are the differences between Visual Basic, VBA and VBScript? When would it be appropriate to use one as opposed to another?

1 Answers   Infosys,


Hello Guys, If any body looking for "worksoft certify tool training in bangalore", please contact me aimansaud@gmail.com

0 Answers  


Categories