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...

with out using import sheet came is it possible to get the
excel sheet ?

Answer Posted / chaitu.c

Dim ExcelObj
Dim ExcelWB
Dim NewSheet

Set ExcelObj = CreateObject("Excel.Application")
Set ExcelWB = ExcelObj.Workbooks.Open ("D:\Documents and
Settings\Administrator.SEERVER\Desktop\Test.xls")
Set NewSheet = ExcelWB.Sheets("ranga")
NewSheet.Cells(1,1)= "CHAITU"
ExcelWB.Save
ExcelObj.Quit

Set NewSheet = Nothing
Set ExcelWB = Nothing

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is QTP supports Unix. If yes, then how the test automation is done?

2188


How many ways is to parameterize the value?

1140


What is a data driven test in qtp?

1034


Where you are storing your script?

1096


how do u manipulating INI, DLL and / or registry files in support of your test environment? actually what do u mean by INI and DLL or registry files. plzzz its urgent do answer

2017


1.How to record ,capture and also script to capture the close buttons. 2.How to record ,capture and also script to capture the options ---File ->save and File ->close in a browser and PDF files. 3.How to compare the Excel sheet values in a report using QTP scripting. 4.How to compare 2 PDf reports using QTP scripts as well reording. 5.How to compare 2 Excel reports using QTP scripts as well reording. 6.How to save a PDF report to a folder and then translate the report to an Excel type of report and compare that Excel Report with an other excel report. Please clarify me

2154


what is error and fault in terms of software quality?

1913


Whats the realtime QTP testing process

2466


What is difference between design time and run time data table?

1139


i have a doubt can anyone tell me where are scripts stored while using QTP.Tell me the exact procedure takes place in real time?like how we call scripts how to proceed after writing scripts?how scripts are executed etc?i heard some use Qc whether others dont use.so tell me whole procedure for both the things it will be a very big help.as i have interview i want to have whole idea on this.its very urgent.

1915


How you can write contexts to text file in qtp?

1110


Dear All , For UFT 12.02 which version QC or ALM will support ? Thanks Balaji

1395


What is the architecture of your project? Can any one answer for this question plz........

1882


what is ODC and GDC?

7883


What are the different types of checkpoints?

1054