Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
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
|Excel VBA - open a DataValidation dropdown||6||21|
|Copying and pasting pictures from Excel||2||18|
|Filter multiple Pivot Tables in Excel 2013 using formula or cell reference||10||21|
|Moving Range Names/Formulas over to new WB||21||16|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!