Showing posts with label QTP Script to copy one worksheet data of Excel Sheet to other worksheet. Show all posts
Showing posts with label QTP Script to copy one worksheet data of Excel Sheet to other worksheet. Show all posts

QTP Script to copy one worksheet data of Excel Sheet to other worksheet-VB Script to copy one worksheet data of Excel Sheet to other worksheet



QTP Script to copy one worksheet data of Excel Sheet to other worksheet


dim a,b
set a=createobject("Excel.Application")
a.visible=true
set b=a.workbooks.open("D:\abc.xls")
b.sheets("sheet1").Copy,b.Sheets(1)
b.save

Creats copy of sheet1 in new excel worksheet

Related Posts Plugin for WordPress, Blogger...

Fun and Knowledge