Exit EditMode of a second Excel Instance from Current Application

[Jaafar Tribak]

Tom showed here a nice way to force excel out of edit mode via a Windows timer. I want to extend this so it can be performed on a second running instance of excel .

I guess this should be fairly easy to do by activating the second instance and sending the appropriate key/mouse strokes/clicks.However, this wouldn't be an elegant way as this would desactivate the current application by bringing the second instance window to the forground .

Now, if the current application could first check if the second application is in edit mode and if so exit the edit mode discretely behind the scenes that would nicely prevent any cross-data communication code getting stuck .

Any thoughts on how this could possibly be achieved?

Regards.