Vba download table from sap application

Asked By Jai Zadok 60 points N/A Posted 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?
 

• Status: Open
• Question Views: 1233
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Business Management

Answered By Grace tomp 0 points N/A #156710

Vba download table from sap application

Hello Zadok

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.

Thanks.

About Grace tomp

Questions
2

Answers
18

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 10/23/2012
• Question Category: Business Management