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.

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.
>
>
>

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


"Tom Ogilvy" <(E-Mail Removed)> wrote in message
news:7F4657F5-AD6A-4DC5-90A6-(E-Mail Removed)...
>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.
>>
>>
>>