You can't copy a range to a closed workbook. Usually, it is just easier to
open the workbook, paste the data, save the workbook, close the workbook.
(or close with save).

The only alternative would be if the data is laid out like a database and
you want to access with ADO. then you could append records to it (but
technically, it is still being opened by ADO).

--
Regards,
Tom Ogilvy


"ritu" wrote:

hi am trying to copy a range from source workbook to a worksheet in
destination workbook(closed) in a different drive. i checked previous
topics but i am unable to get appropriate code to copy range to closed
workbook. please help