Scipting to another software

I am new to VBA, but learning quickly.  My husband is an Intermediate-Advance user and we both have the same question.
 
We want to take data from an Excel spreadsheet (different columns) and write a script in order to have this information keyed into another program (ex.  SAP)  We have several change of addresses to make in  our main system and want to have it automated.
 
I have seen it done before at previous companies that I have worked, but never asked what code to use in order to accomplish this task.
 
Any help would be greatly appreciated.
 
 

First off I will point out that this is a VBScript forum and VBA is not VBScript which is not VB which is not VB .Net. They do all have a common ancestor though so they are all similar. In your specific case the way that you will do it will depend on the API that your main system ("in  our main system") whatever that might be exposes. Most likely if it exposes an API at all it would be in the form of a COM object, but there is no way for us to know that.

If the target system (whatever that may be) doesn't expose an API, but has some kind of data import mechanism, another option may be to have a script generate an output file with the data formatted appropriately and then trigger the import.

If I figure out well what you looking for you should go to do a recording of script from SAP directly, by default the scripts are saved as vbs file extension, you can to rename like a txt file to get the VBA code. To record a script in SAP on top panel click on option and go to recording a script...I hope it help you.