copy a worksheet from a closed file?
 

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

copy a worksheet from a closed file?
 

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

copy a worksheet from a closed file?
 

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