Hi,

In Microsoft Excel we are using a formula which takes information from another open application and enters the information into a cell in Excel.

The formula we are using is:

=AXLDDES|'AV..L'!MID_PRICE

Is there anyway to imitate this in FileMaker, perhaps with a DDE command? so that the information is brought into a field in FileMaker

Many thanks

DDE is very old and very dead technology. Not supported by Microsoft anymore. But if you insist on using it, you can only *send* DDE commands from FM, FM does not respond to any DDE commands sent to it from another app.

To get data into FM you have these options

- web interface

- ODBC

- import

- paste

- plugin API

You can run a script in FM from the outside (see "ActiveX" in the FM help file) but unfortunately you cannot pass that script a parameter, which would solve all your problems because then you could pass your calc to FM as the script parameter.

Go here and add an entry asking for script parameters through ActiveX.

http://www.filemaker.com/company/product/feature_request.html