Excel VBA Projects

How to automate repetitive SAP tasks using VBA [繰り返し作業をVBAで自動化させてみましょう]

Kommentare

Kommentar veröffentlichen

Beliebte Posts aus diesem Blog

How to automate repetitive SAP tasks using VBA [反復作業をVBAで自動化させてみましょう]

Bild
  [日本語版] As digitilization progresses, the need to automate and standardize repetitive tasks increases. If you are using SAP for your daily business operations utilizing Excel VBA could present a easy to implement solution for automizing reoccuring and time-consuming tasks. In this article I am going to show you how to setup excel to access SAP's GUI Scripting API and how to automatically login to the system. The login process serves as a base for further GUI Scripting programming and eventually automization of tasks. The Setup Since SAP does provide an API you only need to activate the reference in the VBA-Editor to access the functionality of SAP via Excel. In order to do so you need to open your VBA-Editor (Press Alt + F11) and access the references of your project by clicking on "Tools". Then you need to select the file "sapfewse.ocx"  as shown in the picture below. After doing so SAP GUI Scripting API is activated by ticking the corresponding box
Mehr anzeigen

How to turn your PC into a Tennis court by using pygame [Pygameを利用してパスコンをテニスコートに変更させましょう]

Bild
Turn your PC into a Tennis Court [日本語版] What if I told you that recreating the all-time classic game Pong might be significantly easier than you think? In this article I will show you a way of programming Pong on your own pc using Python. I will make use of the pygame library, which you can find more about on this link. This article will be divided in the following chapters: Creating a Screen Creating the court, pads and ball Making the ball move Making the pads move 1.) Creating the Screen Before we start building our own screen, we have to initialize pygame module in our code first. So first things first by adding the command pygame.init() to our code we are able to execute all the nice functions pygame has to offer for us. In order to create a screen/window with pygame we can make use of an in-built function which is called pygame.display.set_mode(). This function requires us to set the height as well as the width of the screen we are trying to implement. I set
Mehr anzeigen