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" <(E-Mail Removed)> wrote in message
news:75F45EA3-15DC-47C4-AD17-(E-Mail Removed)...
> 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