Why multiple instances of XL? you can do two monitors with just one
instance... Check out this link...

http://www.cpearson.com/excel/MultipleMonitors.aspx

If you still need to have multiple instances then you are pretty much on
your own. There is no easy way to get one instance to recognize the other.
--
HTH...

Jim Thomlinson


"Bill-41" wrote:

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!!