The data file that will be used for input must have some kind of delimiter or separator. In most cases, you will find that comma-separated variable (.CSV) files are the best choice because they can be edited in Microsoft Excel.
Remember, the important thing is to make sure the correct data is in the correct columns and in the correct order.
CSV file being edited in Excel.
Flat-file separated by the | symbol.
AUTOMATING LINE-ITEM DATA ENTRY VIA SAPGUI
Step 1: Setting the stage
Step 2: Activating SAPGUI scripting
Step 3: Preparing the input data file
Step 4: Recording the data entry
Step 5: Analyzing the VBS script
Step 6: Automating the VBS script creation
Step 7: Running the VBS script program generator
Step 8: Playing the VBS script to enter the line items
Step 9: Troubleshooting
Review: Conclusion and more resources
This was first published in August 2005