Paul,

Book1 and book2 are workbooks, they are not necessarily separate instances.

If you have two instances of Excel, I assume the code is in one of them. To
access the other, you need to go via an application object. But, how do you
get a handle to the other on e? AFAIK, when setting a variable to an
instance of Excel, you can not pre-determine which you will get. So you
might just end up with the same instance as you are in.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul" wrote in message
...
Thanks Bob,

I am running two instances of excel, i.e. both are running
on the same machine. one is book1.xls and the other is
book2.xls. Have corrected the quotes problem, but still
cannot get it to work. Aslo have tried to set a variable
to the value --- also with no luck.


-----Original Message-----
Do you really mean separate instances of Excel or
separate workbooks? If the
latter, you need to enclose the worksheet name in quotes,
and you don't need
Application, it is implicit.

Workbooks("book2").Worksheets("Sheet1").Range("a1 ").Value
= _
Workbooks("book1").Worksheets("Sheet1").Range("a1 ").Value


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul" wrote in
message
...
Is it possible to copy cell contents between instances
of
excel??

I cannot get the following code to work. Can anyone
tell
me why?

Application.Workbooks("book2.xls").Worksheets
(Sheet1).Range
("a1").Value = Application.Workbooks
("book1.xls").Worksheets(Sheet1).Range("a1").Va lue


.