Copy data to a closed workbook

[zinny]

how do i copy the data from cell C1 in the active workbook "name1.xls"
to cell D10 in the closed workbook "name2.xls" in "sheet1" without opening the
closed workbook?

[Richard Schollar]

You don't. You'll have to open it up first.

Richard

[royUK]

You can do it with code, but as Richard says you will need to open the workbook first. This can be hidden from the user.

Please Login or Register  to view this content.

[zinny]

thanks, your code worked great.

[royUK]

thanks, your code worked great.

Then you should mark the Thread solved.