Workspace Macro Pro -> use that program. I use it very often for such uses when I need to copy something from Excel to SAP and do not have any import solution available. The I do a recording of changing windows and copy paste actions and just run that program 10-15-20-100 thousand times and go to coffee :D

Problem is that with VBA itself you cannot change programs and send some value from one window to another. With .NET yes, but VBA no.