Hello,

You are right, but my situation is different. I have
two Excel open. If it was one Excel open with two
workbooks you was right. But in my situation - One
Excel doesn't know the other. So I do not have access to
its workbooks.
Thanks anyway... if you have any other solution I
will appreciate if you send it.

Thanks


-----Original Message-----

If you look at the Object Model you'll see that Workbook
is a
collection. Any open workbook should be part of that
collection. So, if
you only have these 2 books open you should be able to
switch from
workbook(1) to workbook(20, using the sheets collection,
and the cells
collection, ranges, etc to grab the data from one book
and copy or move
this to the other.

E.g.

Workbooks(1).Sheets("Sheet1).Range("A1:C50").co py
Workbooks(2).Sheets("Sheet1)Range("A1").Paste

Something like that from memory anyway. use VBA Help for
the workbooks
collection and you'll get the general idea.

HTH

Art


--
HiArt
---------------------------------------------------------
---------------
HiArt's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=19953
View this thread:
http://www.excelforum.com/showthread...hreadid=345847

.