Hi Ron,

Thanks for your providing your ADO example. You specified setting a
reference to
Microsoft ActiveX Data Objects 2.5 library
msado25. does not exist on my Win 98 machine. I think it was first shipped
with Win2000. However changing the reference to version 1.5 and your example
works fine.

Don't suppose many still use Win98 - but just in case!

Regards,
Peter T

"Ron de Bruin" wrote in message
...
Hi nc

Try this example
http://www.rondebruin.nl/ado.htm

Or other ways on my tips page
http://www.rondebruin.nl/tips.htm

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



"nc" wrote in message
...
Hi

Can one copy a range from a closed file and paste in an
open one?

Thanks.