SAP & VBA: simple Excel application with User Form

SAP & VBA: simple Excel application with User Form

SAP BW
SAP GUI Scripting is an automation interface that enhances the capabilities of SAP GUI. Using Visual Basic users may automate repetitive tasks by running scripts. Developers on the other hand may build complex tools to make repetitive time-consuming tasks quick and easy. In SAP and VBA: How to Start blog post, you can check how to start working with SAP GUI scripting. Below you can find simple example of the code to be run from Microsoft Excel. Example In the post I will show how to create simple Excel application with UserForm. In the UserForm user will be able to choose SAP Transaction (T-Code) and then the chosen transaction will be run in SAP. Tutorial Open Excel and run Visual Basic editor (from Developer tab).Using Visual Basic editor in MS…
Read More

SAP & VBA: How to start

SAP BW
Visual Basic for Application can be very helpful when is used for automation in Microsoft Office (especially in Excel). But it is not well known that VBA, together with Excel, can be used in SAP systems (those accessible from SAP Logon, for example SAP ERP, SAP BW). (more…)
Read More