copy to closed workbook on a different drive

[Max Bialystock]

How can I copy the contents of A1 in C:\users\book1.xls to C9 in
D:\users\book2.xls and to C9 in D:\users\book3.xls.



Let's assume that both workbooks on drive D are closed.

 

[Dave Peterson]

Record a macro when you open book2, do the copy|paste and close book2 (and
save).

Continue recording when you open book3 and copy|paste and close book3 (and
save).

And you'll see the code.

 

[Greg Glynn]

Max,

Loved your last Production ("Guys and Dills") by the way.

You can do it a copy of ways. If you don't want to open the
workbooks, you can hard code the entries like this:

The formula for D:Book2 C9 is {=C:\users\[book1.xls]Sheet1'!A1}
The formula for D:Book3 C9 is {=D:\users\[book2.xls]Sheet1'!C9}

Note: The parentheses are part of the formula - {Freaky, I know.}

Good luck.

 

[Greg Glynn]

Hmmm ...

I may have misled you here. This technique above works when you
initially have both workbooks open, and you refer the the remote
workbook with an '=' first.

Once you have the reference in the cell, you can all workbooks and
reopen and your results workbooks will try to perform an update.

The result is what you need though (and I was wrong about the
parentehses). sorry for the confusion.

Greg