Hi. I have two excel applications open (on seperate monitors) I want to
use VBA to copy information from one spreadsheet application to a different
spreadsheet.

Manually I would activate the 1st application with the mouse, copy then
activate the other application and paste. I'd like to automate this

I'm not sure how to reference the two open excel applications.

Thanks for any help!!