Deleting the excel sheet before exiting the script

[Rekha]

Hi,
What about the following script.
It creates an excel file with 5 sheets.
Then removes the second sheet.
You will find the mentioned sheet deleted from the workbook.

Let me know whether it works out for you or not!

Code:

Set xls=createobject("excel.application")
Set xls1=xls.workbooks.add
For i=0 to 4
xls1.worksheets.add
next

xls.worksheets(1).name="Browsers"
'xls.worksheets(2).delete
xls1.saveas"E:\Child Object Properties2.xls"
xls.save
xls.quit
Set xls=nothing
Set xls1=nothing