How to transfer data from excel to another window base app via macro

[meansmpm]

Hey can some provide me with a simple macro to transfer data from excel to another window base app. Basicly I want the macr to copy the date from say cell A3 to another window base app and then go back to the excel and copy the date from cell N3 and copy that information to the same window base app and continue this process untill it copies all the information form the excel around 400 plus line.

 

[Makrini]

Probably worth telling us what Windows based Application

i.e - if it is an Office application like WORD this doesn't even need a Macro...

 

[meansmpm]

I am transfering the data from Excel to a AS400 windows base app.