Hi H.

You can use ADO
http://www.rondebruin.nl/ado.htm

Or this example
http://www.rondebruin.nl/copy7.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"H." wrote in message ...
There is a workbook on our network that I do NOT want to open, but I still want to select a certain range in that closed workbook
and paste it in my own (open) workbook. Possible?

I have all the rights on that unopened workbook. So that is not a problem.

H.