I would close one instance and open that workbook in the remaining instance.

I could copy and paste between two different instances, but my formulas were
lost. (xl2003/winXP).

Maybe that's not a problem for you.

Boba wrote:

Hello,

You're absolutly right - 2 instances of Excel didn't
make any benefit But in out place there is a software
which have the feature to export the data to Excel via
the automation. I don't have any control on that software.
When I export twice I got two Excels open. Now I have to
comapre the data between them - The question is How can I
do it ?

Thanks.

-----Original Message-----
Hello Boba-

I'm replying more out of curiosity than anything else,
and was wondering why
there are 2 "instances" of Excel running in the first
place. I am truly at a
loss as to what benefit this offers. It has always been
stressed to me that
this is something to be avoided for numerous reasons,
all of which make sense.

If you could more fully explain what your ultimate goal
is, perhaps someone
could offer some useful suggestions.

Thanks |:)

"Boba" wrote:

Hello,

I have 2 windows of Excel with data. The data are
separated (not in one workbook). I would like to copy
the
data from one Excel to another via VBA or Macro.
How can I do that ?

Thanks


.


--

Dave Peterson