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





No comments:

Related Posts Plugin for WordPress, Blogger...