Unopened workbook

[H.]

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.

 

[Ron de Bruin]

Hi H.

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

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