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

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

Thanks for the tip.

Not sure yet if it'll do what I need, but looks like maybe. Checking it out
now.



"Otto Moehrbach" wrote:

You can try ADO

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

HTH Otto