Copy an Excel sheet using VBA

[Jim]

Using Excel 2000.
Is it possible to copy a worksheet from a closed workbook on a computer on a
LAN into a running Excel workbook on a different computer on the same LAN
using VBA.

 

[Guest]

I think the quick answer is:
You would need to open both copies in a single instance of excel on the
computer with the code.

If you want to extract data organized as a table and treat the sheets on the
workbook as databases, then you might examine ADO.
http://www.erlandsendata.no/english/index.php?t=envbadac

I have never used netDDE, but I am pretty sure it does not support copying a
worksheet between closed workbooks.

 

[Jim]

Thanks Tom,
I'm using ADO now but was hoping there was some Excel/VBA quickie way I'd
never heard of.