Dynamic data exchange between two computer on a network with VBA

  • Thread starter Thread starter Denis
  • Start date Start date
D

Denis

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

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)
 
Back
Top