Settlemen rules excel macro

Former Member — Wed, 23 Jan 2019 18:03:52 GMT

Hello everyone. Many thanks for are reviewing this question.

I am trying to create a macro in order to automatize the settlement rules and I have a question. What VBA code can I use for the macro to recognize the first empty field?

As the image shows, what I want is that the Macro start filling out the information in the settlement rule from the first empty field.

I know this would be the code for the first empty cell in excel:

ActiveSheet.Range("a1").End(xlDown).Offset(1, 0).Select

But I do not know how to do it in SAP

I will realy appreciate your answers

Many thanks!

Re: Settlemen rules excel macro

Sandra_Rossi — Thu, 24 Jan 2019 07:22:11 GMT

Do you want to code it using "SAP GUI Scripting" ? (SAP COM Library for scripting dynpros)

If so, you should say it in place of "VBA code" and add that user tag.

topic Settlemen rules excel macro in Application Development and Automation Discussions

Settlemen rules excel macro

Re: Settlemen rules excel macro