Hello,

I requested by CyberTaz to ask my question again and
describe the situation I have, so here it's :

In our place we have a software. That software has a
small feature "Export to Excel". Whenever I operates
the "Export" I got new instance of Excel with data. Most
of the time I must compare data between two reports
I got in Excel. So, on my desktop there are two instances
of Excel, instead of doing the same steps over and over
again ( Select all cells, Copy, go to other Excel, Paste
the data and etc... ) I would like to write a macro that
will do the sisyphean work.

My question is : What should I write in VBA so I can copy
data from one instance of Excel to another ?
( My last option will be to write 2 macros, one for copy
the data and save it on the disk. The second macro will
load the saved file and compare the data with the other
report )

Is anyone has better solution ?

Thanks.