Micro Focus QTP (UFT) Forums

Micro Focus QTP (UFT) Forums > Micro Focus UFT (earlier known as QTP) > VB Scripting/Descriptive Programming > Need to embed worksheet to already existing excel
Full Version: Need to embed worksheet to already existing excel
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

mahaktikoo

09-14-2012, 04:19 PM
Hi guys,

I am trying to embed worksheet to already existing excel using vb script in QTP.

I am using the same script that adds pictures, but this doesnot seem to work.

Code:
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True

Set objWB = objExcel.WorkBooks.Open("C:\test.xlsx")
Set objWS = objWB.Worksheets(3)

objExcel.ActiveCell.Worksheet.Pictures.Insert("C:\img\abc.jpg")

objWB.Save

objExcel.Quit

Can anybody help me out here. Thanks in advance. Smile

Regards,
Mahak

krr

09-27-2012, 12:13 AM
Do you want to move an excel worksheet from one excel(abc.xls) to another excel(xyz.xls)?
Micro Focus QTP (UFT) Forums > Micro Focus UFT (earlier known as QTP) > VB Scripting/Descriptive Programming > Need to embed worksheet to already existing excel