	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

QTP - Export to Excel

Asked by cmushaun in VB Script, Visual Basic Programming, Test / Validation Development Software

Tags: QuickTest Pro, VB

I have a QuickTest Pro function below (incomplete) that I need to use to export some information to an .xls excel sheet.

The function below takes in 3 string variables, and I want it to export the data to a spreadsheet on x:\ drive.

I will call this function several times during the run of the script. Each time it is hit, I want it to write a new line/column in the spreadsheet.

The spreadsheet currently has the headings:

Start_Time in A1, End_Time in B1 and Trans_Name in C1 of the excel sheet.

View the Solution FREE for 30 Days

         
             Function ExportmyData(sStartTime, sEndTime, sTransName)
 
End Function

20091021-EE-VQP-81 - Hierarchy / EE_QW_3_20080625

Hall of Fame

1. suveer_p...30,513
2. MaduKp10,744
3. TheLearn...8,000
4. objects6,236
5. a_b6,220
6. jason11784,500
7. Christofer...4,200
8. CEHJ4,000
8. mas_oz...4,000
10. cdbosh3,200
11. pcelba2,672
12. ksivananth2,328
13. DarrenD2,000
13. angelIII2,000
13. hewittg2,000
13. tbsgadi2,000
13. graye2,000
13. rascalpants2,000
13. shalomc2,000
13. MASQUE...2,000
13. contactka...2,000
13. LSMCons...2,000
13. hazgoduk2,000
13. kaufmed2,000
13. MuraliKanth2,000
13. Qlemo2,000
13. rpnman2,000
13. lacrewga2,000
13. Ben_ocm2,000
13. psasik2,000
13. rdogmartin2,000
13. feridun2,000
13. jasonrmac2,000
13. Africans2,000
13. Zo3FoL2,000
13. leakim9712,000
13. douglashope2,000

1. suveer_p...30,513
2. MaduKp16,769
3. sunnycoder15,750
4. TheLearn...9,500
5. objects8,636
6. a_b6,220
7. CEHJ4,800
8. ksivananth4,528
9. jason11784,500
10. roos014,498
11. Christofer...4,200
12. mas_oz...4,000
13. jim_cakalic3,600
14. cdbosh3,200
15. paulop1...3,000
16. pcelba2,672
17. mplungjan2,500
17. graye2,500
17. PUNKY2,500
20. nobus2,400
21. LSMCons...2,150
22. ahoffmann2,000
22. DarrenD2,000
22. angelIII2,000
22. hewittg2,000
22. tbsgadi2,000
22. Dhaest2,000
22. rascalpants2,000
22. rionroc2,000
22. shalomc2,000
22. MASQUE...2,000
22. SGyves2,000
22. budchawla2,000
22. deroby2,000
22. contactka...2,000
22. hazgoduk2,000
22. exhaust2,000
22. JesterToo2,000
22. kaufmed2,000
22. MuraliKanth2,000
22. Qlemo2,000
22. rpnman2,000
22. realParker2,000
22. DaTribe2,000
22. lacrewga2,000
22. jackmcbarn2,000
22. marklorenz2,000
22. Ben_ocm2,000
22. HoggZilla2,000
22. psasik2,000
22. rdogmartin2,000
22. feridun2,000
22. jasonrmac2,000
22. Africans2,000
22. Zo3FoL2,000
22. leakim9712,000
22. douglashope2,000