We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Dim record_counta record_counta = DataTable.GetSheet("SOLNData").GetRowCount For y = 1 to record_counta 'Goes thru all rows. SOLN_Qty=Datatable.Value("OrderQty","SOLNData") 'Sets SOLN_Qty to whatever is in row 1 rCount = Browser("SAP NetWeaver Portal").SAPPortal("SAP NetWeaver Portal").Frame("213414_FRAME").WebTable("Number").RowCount 'WebTable row count = same as y For z = 2 to rCount 'start at row 2, because row one is the headers 'Issue: next line loops through all rows and puts the value of SOLN_Qty in each row of the WebTable, and we only need it in whatever row "z" is. Only need the next line to execute once. Then go get the next y, put it in the next z. Browser("SAP NetWeaver Portal").SAPPortal("SAP NetWeaver Portal").Frame("213414_FRAME").WebTable("Number").ChildItem(z,4,"WebEdit",index).Set SOLN_Qty Next DataTable.GetSheet("SOLNData").SetNextRow Next
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Excel - Summing a column based on criteria from another column||5||48|
|Excel formula with SUMIF and SUBTOTAL||13||45|
|Track use of a script by logging username, date & time to an excel file.||4||52|
|Excel Add-in Subscript out of range||5||28|
Join the community of 500,000 technology professionals and ask your questions.