How to create a new excel sheet using QTP and then close it.

Interview Candidate
Oct 9th, 2007
3
12132

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

prashanth.n
Profile Answers by prashanth.n Questions by prashanth.n

Feb 24th, 2008

Hi ,

Below code will be helpful for creating and closing excel sheet

Dim xlApp
Dim xlBook
Dim xlSheet

Set xlApp=CreateObject("Excel.Application")
Set xlBook=xlApp.workbooks.add
Set xlSheet=xlBook.activesheet
xlSheet.cells(1,1)="helloo"

xlBook.saveas "c:test.xls"
xlApp.quit