August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!
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.
Join the community of 500,000 technology professionals and ask your questions.