Get the next SAP object in loop – iteration issue

Sap Scripting can be really tricky sometimes. My job is to help You and solve any mistery case. In this article I’m going to show You a trick, which will help You to get next SAP object in loop and get through the iteration issue.

Continue reading “Get the next SAP object in loop – iteration issue”

How to loop through MM02 tabs in SAP?

Between SAP tickets, I noticed that there may be a problem with recording actions when filling in different fields on several different tabs of a given transaction. In this article I’m going to show You how to run smoothly between tabs – loop through MM02 tabs in SAP.

Continue reading “How to loop through MM02 tabs in SAP?”

How to automate scrolling in SAP table?

Recently I received suggestion to dig in the problem of pop up table-windows in SAP, which content is bigger than its size. The funniest thing is that, it’s not issue only in SAP scripting, but also such software like Winshutle is having some troubles with that. In this article I’m going to get throught this problem and present You 2 ways of how to automate scrolling in SAP table.

Continue reading “How to automate scrolling in SAP table?”

How to copy object collection data to worksheet?

The main topic seems to be really simple and obvious, but the truth is probably quite different than You could expect. In this article I want to show You how to copy object collection data into worksheet, but faster.

Continue reading “How to copy object collection data to worksheet?”

How to create & use User-Defined Function (UDF)?

Usually there is already built-in function, which can meet your requirements. But sometimes this is not exactly what You needed or it’s not exist. In this article I will show You how to create and use User-Defined Function (UDF) in VBA.

Continue reading “How to create & use User-Defined Function (UDF)?”

How to connect to Microsoft SQL Server using VBA?

When it comes to big amount of data, Excel application is not the best solution to work with, in case of storage. Much better fit would be a database like Access or MSSM. In this article I’m going to show You how to connect to Microsoft SQL Server using VBA.

Continue reading “How to connect to Microsoft SQL Server using VBA?”