Communication between two Apps using Applescript


I’d like to copy data over from excel and paste it in another application (SAP). I’m not too sure how to go about this at the moment, but my primary question is whether Applescript can help me identify the windows I need to activate to copy/paste data. At this point I enter excel via Applescript and run a macro to copy the required information.

Ideally, it would be best if I could open SAP via Applescript and select the correct system to log on to and finally paste the data where required. To do this however I would require user input in different fields to get to the correct place in order to Paste the data. Wow this sounds confusing! I hope someone familiar with SAP will understand what I’m getting at.

So far I have the code to open up excel and run the macro and then start SAP and thats where I’m stuck.

I’d really appreciate any help (even if anyone could just let me know if this is even possible).