Showing posts with label qtp script to get count of worksheets in an excel sheet. Show all posts
Showing posts with label qtp script to get count of worksheets in an excel sheet. Show all posts

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





Related Posts Plugin for WordPress, Blogger...

Fun and Knowledge