You can try ADO

http://www.rondebruin.nl/ado.htm

HTH Otto

"mark" wrote in message
...
Hello.

Is there a way to copy an entire worksheet from a closed file?

I can open the file, and then copy just the worksheet I need out to a new
workbook, but, sometimes the files can be large.

If it's possible just to get the one sheet, that'd be quickest.

Thanks.
Mark