Append data to next empty row

[former_member975213]

Hello, I am rather new with SAP scripting and just a googler for VBA in general.

I am using session.findById(...../.....[col,row]).text = "blah"

Example

session.findById(blah/blah/blah[2,25).text = "blah data 1"

session.findById(blah/blah/blah[3,25).text = "blah data 2"

session.findById(blah/blah/blah[4,25).text = "blah data 3"

session.findById(blah/blah/blah[5,25).text = "blah data 4"

As of right now my solution is to actually input data into a high level row, say 25. In the event there is already data up to 25, my script will fail. What is the proper solution to append to the end? I have attempted to remove the 25, change to 0, etc. Lots of google searching and no luck on this.

Thanks for any assistance.

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

• Profile https://developers.sap.com/tutorials/community-profile.html
• Tips for Questions: https://community.sap.com/resources/questions-and-answers
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

Alex