QTP Script to copy one excel sheet data to other excel sheet-VB Script to copy one excel sheet data to other excel sheet

QTP Script to copy one excel sheet data to other excel sheet



Set excel=createobject("excel.application")

excel.Visible=True

Set workbook1=excel.Workbooks.Open("C:\qtp1.xls")

Set workbook2=excel.Workbooks.Open("C:\qtp2.xls")

workbook1.Worksheets("Lakshmi").usedrange.copy

workbook2.Worksheets("Sheet1").pastespecial

workbook1.Save

workbook2.Save