Use ActiveX DLLs to Send Mobile Notifications from Your SAP System

  • by Faisal Altaf, SAP Technical Division Head, Al Yamamah Steel Industries Co.
  • August 13, 2012
Discover how to create ActiveX Dynamic Link Library (DLL) in Visual Basic 6 (VB6) and call COM Class of VB.NET from VB6. Then use this VB6 ActiveX DLL from SAP ABAP with Object Linking and Embedding (OLE). Learn how to integrate Microsoft Excel and Outlook with SAP systems to create files and send emails with attachments using OLE. Learn how to send messages to mobile devices from SAP systems and find out the way to register ActiveX DLLs and COM Classes on different presentation servers.
Key Concept
ActiveX Dynamic Link Libraries (DLLs) are the set of instructions that can be written in different languages and can communicate with one another independent of language. They can contain one or more class modules and one class can have multiple methods. You can write an ActiveX DLL in Visual Basic and use it from SAP ABAP.

In many business scenarios you are required to generate a document, send an email attachment, or send a notification to mobile devices. Typically, you have to perform a lot of configuration for sending emails and mobile notifications. The simplest way to do this without any extra configuration is to use Object Linking and Embedding (OLE).

An example scenario is that you need to create payslips for employees in Microsoft Excel. You then want to send the payslips to employees’ email addresses as attachments. A notification then goes to the employee’s mobile device that his or her salary has transferred to the bank account and the payslip has been sent to the provided email ID. To do this, you need to follow this four-step process:

  1. Create and use the ActiveX DLL
  2. Integrate Microsoft Excel for generating a payslip
  3. Integrate Microsoft Outlook for sending an email
  4. Create and use ActiveX DLL and COM Class for sending mobile notifications

Before getting started, you need to meet a few prerequisites:

  • Visual Basic 6 (VB6) and Visual Studio (for developers)
  • Microsoft .NET framework 2.0 (for end users)
  • SAP GUI for Windows (for both developers and end users)
  • Microsoft Excel (for both developers and end users)
  • Microsoft Outlook (for both developers and end users)

Create and Use the ActiveX DLL

This step involves four substeps:

  • Create the ActiveX DLL project
  • Test and debug the ActiveX DLL project from another Visual Basic EXE standard project
  • Test and debug the ActiveX DLL project from the SAP ABAP program using OLE
  • Create and register the ActiveX DLL

Faisal Altaf

Faisal Altaf is a certified development consultant. He has more than seven years of experience and currently is working with Al Yamamah Steel Industries Co., Saudi Arabia, as the SAP technical division head. He completed his MS in software engineering and intends to complete his Ph.D. in the field of SAP.



See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.