Real-time data exchange (DDE?)

[Konstantin Romanov]

Is it possible to have something like DDE data exchange with Excel X?
I can't find any mention of real-time data exchange supported by Excel
on Mac - aren't there any support at all? I want to have a possibility
to link data of our company's product with Excel.

The only thing comes to mind is to have something like Excel add-in
which will provide the Excel functions which will talk to our app, but
it's look a bit weird and doesn't solve problem of pushing data from
Excel to our app in any user-friendly way.

 

[Jim Gordon MVP]

Hi Konstant,

Maybe.

If you search the help file in the Mac visual basic editor for DDE it says
"Windows only."

But... In the Excel X Visual Basic Object Editor:

The "Shell" command is supported (that's how you get one application running
from a another one on the Mac).

If you control-click in the object editor and display the hidden commands
you'll find these DDE commands still in there: DDEInitiate, DDEExecute,
DDEAppReturnCode, DDEPoke, DDERequest, DDETerminate.

Hidden commands are supposed to work to ensure backwards compatibility. I
didn't try setting up a DDE exchange with Excel X, but I would give it a 90%
chance that it works.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

 

[Alexandre Nikolov]

Check if you have "RTD" (RealTimeData) command available
If COM is available for MAC, RTD should be available. Then you need to write a COM object that is going to provide the data. More on this topic you can find in MSDN

DDE is very old technology and M$ does not fix bugs in it and does not enhace it since Windows 95 (read it is supported only for backwords compatibility)

 

[Jim Gordon MVP]

Check if you have "RTD" (RealTimeData) command available.
If COM is available for MAC, RTD should be available. Then you need to write a COM object that is going to provide the data. More on this topic you can find in MSDN.

DDE is very old technology and M$ does not fix bugs in it and does not enhace it since Windows 95 (read it is supported only for backwords compatibility)

COM is Windows only. RTD is Windows only. DDE is both Mac and Windows.

-Jim