N/APosted on - 09/15/2012
We were using VBA old version as financial software. Now company upgrades the software from VBA to SAP financial. First of all we need make possible to use data from SAP to VBA in emergency. What coding must be used for VBA download table from sap application so that we can run both software?
Vba download table from sap application
You can export the data from excel to SAP using VBA, but you need to create from RFC in SAP as well that will handle the data you will send.
Follow the simple steps:
Step- 1. Create a RFC function in R/3 that will read a file from specific location and perform the respective transaction.
Step- 2. Create your excel file with respective file format and call the RFC function in SAP passing the parameters as file name and other required details.
Step- 3. SAP coding for RFC will be a single time activity and then on wads you can just create excel file for upload and use VBA code to initiate the RFC call.