QTP Script to set the width of first column of an excel sheet-VB Script to set the width of first column of an excel sheet

QTP Script to set the width of first column of an excel sheet



dim a,b,c

set a=createobject("Excel.Application")

a.visible=true

set b=a.workbooks.open("C:\QTP.xls")

set c=b.worksheets(1)

c.Columns(1).ColumnWidth=50