Showing posts with label QTP Script to copy one excel sheet data to other excel sheet. Show all posts
Showing posts with label QTP Script to copy one excel sheet data to other excel sheet. Show all posts

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

Related Posts Plugin for WordPress, Blogger...

Fun and Knowledge