Hi All,

I am using a separate instance of excel to display an export from an
excel application in a different instance of excel (the original
instance being driven entirely by modal userforms which I don't want
to interrupt).

One export is a data integrity check where it exports, does some
checks, and then displays the lines with potential issues for the user
to investigate back to hard copy documents.

I would like to display a MsgBox in that instance of excel, using code
in my original instance, telling the user which specific test was
found to have potential data issues (makes it easier for the user to
target their investigation / checking).

However, I cannot work out how to make it display a MsgBox
in the other instance of excel.

Any suggestions?

Thanks,

Alan.


PS: I have looked through the excel object model for where a
MsgBox sits, but I cannot seem to see where it fits into the
hierarchy. I was hoping to be able to reference it something
like this:

+-+-+-+-+-+-+-+-+-+-+

This Instance Implicit:

MsgBox "Hello"

+-+-+-+-+-+-+-+-+-+-+

This Instance Explicit:

Thisworkbook.Parent.MsgBox "Hello"

+-+-+-+-+-+-+-+-+-+-+

Other Instance (objExcel being the new instance of excel):

objExcel.MsgBox "Hello"

+-+-+-+-+-+-+-+-+-+-+