data feed

  • Thread starter Thread starter coyote
  • Start date Start date
C

coyote

is it possible to feed data between two running instances
of excel on the same computer???

like change a number in a excel file in one instance and
have it appear in another file in another running instance
of excel???
 
coyote said:
is it possible to feed data between two running instances
of excel on the same computer???

like change a number in a excel file in one instance and
have it appear in another file in another running instance
of excel???
Click to expand...

For a slightly way of handling interprocess communication, see

http://groups.google.com/[email protected]

As for your specific request, if in Excel instance A you make a change to
workbook A.XLS, the only way you could see the change in a different file
(presumably via an external reference link to A.XLS) loaded in Excel
instance B would be to save A.XLS in instance A and run a macro in instance
A that uses Automation to connect to instance B and updates links. In other
words, this would require a bit of programming.
 
For you specific request an easier way would be to use a DDE link between
the two instances.

=Excel.Sheet.8|Book1!'!Sheet1!R2C1'

to do that, from the source workbook select the cell, do edit =>copy

go to the destination (linking workbook) do
Edit=>Paste Special and select paste as link and choose the Microsoft x.0
format
 
Tom Ogilvy said:
For you specific request an easier way would be to use a DDE link between
the two instances.

=Excel.Sheet.8|Book1!'!Sheet1!R2C1'
Click to expand...
....

Works less nicely when the other instance of Excel is closed, but the OP may
not mind.
 
Recall you said
the only way you could see the change in a different file
Click to expand...

It appears that statement is incorrect.

Also:
OP said:
is it possible to feed data between two running instances
of excel on the same computer???
like change a number in a excel file in one instance and
have it appear in another file in another running instance
of excel???
Click to expand...

I would assume that there is some reason to link them, like one is getting
some type of update which would require it to be open.

If closed, then a simple link would work to get the static data, but the OP
probably wouldn't need to ask that question.
 
Back
Top