Using Excel 2003...

I'm trying to get Excel to switch to another workbook that is open in a
separate instance of Excel. ActiveWindow.ActivateNext works fine to switch
between workbooks open in the same instance of Excel, but won't work for this
purpose. I was looking at using the Index function to cycle through the
different instances, but can't get the syntax right.

Any help is appreciated. Thanks.

--

HTH

Don''''t forget to rate the post if it was helpful!

Please reply to newsgroup only, so that others may benefit as well.