Dynamic data exchange between two computer on a network with VBA
 

Hi

I use a data acquisition system to retrieve data at a
regular time interval with a VBA program. Those data are
stored on a excel sheet that is also updated at a regular
time interval.

I want part of those data (4-5 cells only)to appear on
another excel file located on another computer of the
local network. Those cells also need to be updated at the
same rate than on the first excel file.

I tried to use the "GetObjet" or the "paste special; paste
link" command, but it works only if the files are opened
on the same computer.

Briefly :I want the first file to retrieve data on one
computer (this file is shared) and another file, on
another computer, to get part of those data each time
there is an update.

Thank you

Denis

Dynamic data exchange between two computer on a network with VBA
 

Denis,

Why not just open them both in the same Excel instance?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Denis" wrote in message
...
Hi

I use a data acquisition system to retrieve data at a
regular time interval with a VBA program. Those data are
stored on a excel sheet that is also updated at a regular
time interval.

I want part of those data (4-5 cells only)to appear on
another excel file located on another computer of the
local network. Those cells also need to be updated at the
same rate than on the first excel file.

I tried to use the "GetObjet" or the "paste special; paste
link" command, but it works only if the files are opened
on the same computer.

Briefly :I want the first file to retrieve data on one
computer (this file is shared) and another file, on
another computer, to get part of those data each time
there is an update.

Thank you

Denis

Dynamic data exchange between two computer on a network with VBA
 

How do I do that?

I must admit that i'm a novice with that



-----Original Message-----
Denis,

Why not just open them both in the same Excel instance?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Denis" wrote in message
...
Hi

I use a data acquisition system to retrieve data at a
regular time interval with a VBA program. Those data
are
stored on a excel sheet that is also updated at a
regular
time interval.

I want part of those data (4-5 cells only)to appear on
another excel file located on another computer of the
local network. Those cells also need to be updated at
the
same rate than on the first excel file.

I tried to use the "GetObjet" or the "paste special;
paste
link" command, but it works only if the files are opened
on the same computer.

Briefly :I want the first file to retrieve data on one
computer (this file is shared) and another file, on
another computer, to get part of those data each time
there is an update.

Thank you

Denis


.

Dynamic data exchange between two computer on a network with VBA
 

Denis,

It would just be like opening two local workbooks, just one would be a
network file.

Are you asking how to do it in VBA?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Denis" wrote in message
...
How do I do that?

I must admit that i'm a novice with that



-----Original Message-----
Denis,

Why not just open them both in the same Excel instance?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Denis" wrote in message
...
Hi

I use a data acquisition system to retrieve data at a
regular time interval with a VBA program. Those data
are
stored on a excel sheet that is also updated at a
regular
time interval.

I want part of those data (4-5 cells only)to appear on
another excel file located on another computer of the
local network. Those cells also need to be updated at
the
same rate than on the first excel file.

I tried to use the "GetObjet" or the "paste special;
paste
link" command, but it works only if the files are opened
on the same computer.

Briefly :I want the first file to retrieve data on one
computer (this file is shared) and another file, on
another computer, to get part of those data each time
there is an update.

Thank you

Denis


.