Copy an Excel sheet using VBA
 

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.

Copy an Excel sheet using VBA
 

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/...php?t=envbadac

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

--
Regards,
Tom Ogilvy

"Jim" wrote:

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.

Copy an Excel sheet using VBA
 

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


"Tom Ogilvy" wrote in message
...
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/...php?t=envbadac

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

--
Regards,
Tom Ogilvy

"Jim" wrote:

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.