UFT 14.50 How to set value in Cells Microsoft Excel 2016
We have test UFT 14.50 for SAP Analysis 2.7 .
We use UI Automation , we could read data from excel, but how we should insert data to excel.
This script doest work
Execute "Set Excel_GetExcelObj = GetObject(, ""Excel.Application"")"
Set objSheet = Excel_GetExcelObj.ActiveSheet
Set objCell = objSheet.Cells(18, 5)
objCell.Value = "999"
What has been executed is purely vbscript but not UFT UIAutomation related scripts, does it run fine in a vbs file?
Did you try UI Automation addin in UFT to see how it goes?