qtp script to get count of worksheets in an excel sheet-vb script to get count of worksheets in an excel sheet

qtp script to get count of worksheets in an excel sheet



dim a,b

set a=createobject("Excel.Application")

a.visible=true

set b=a.workbooks.open("D:\abc.xls")

Msgbox b.sheets.count