Skip to Content
Former Member
Jan 18, 2010 at 06:32 AM

Transfer data from Excel to SAP -Important


Hello to anyone who see this request!

Can someone explain line number 3, with example for illustration.

Thank you.

there are certainly several ways to solve this issue. My suggestion is as follows:

1. Record a script for a single customer.

2. Replace all constants to variables in the script. The variables = names of columns from excel sheet.

e.g. "1234567" ---> "Customer"

3. Write a small VBA program that replaces the variables against the current cell in Excel.

4. Run the newly created script.

5. Process in this way all rows from Excel.

6. Done