qtp script to get name of nth worksheet of an excel sheet-vb script to get name of nth worksheet of an excel sheet

qtp script to get name of nth worksheet of 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(1).Name