Linking to Excel

[Gibsob2]

Here is my problem: I run an Excel macro to pull data off a website every 5 minutes, etc. I want a specific field in the spreadsheet to link with a corresponding field in a filemaker database, i.e. every five minutes the macro will run and the data in this field will change; I want the change to be reflected in the filemaker database through a link and not a manual script/import. Ideally, the macro will run in the background and the Filemaker database will be the only thing I use. Any suggestions? Thanks.

[aldipalo]

You need a plugin like scriptfire by dacons or eventscript.

[Gibsob2]

Thanks for your suggestions. Are you saying that there is no easy way to link a FM database to an excel spreadsheet through DDE or something of the sort? My best bet would be to script an import and install a plug-in to run at a predetermined interval? Thanks again.

[Wim Decorte]

FileMaker can use DDE to talk to another App but can't receive DDE calls

(DDE is very dead by the way).

The FM ActiceX model does not allow you to set data directly. So you either need to:

- use ODBC

- run a FM script that imports

- use the clipboard

Since you already have a bunch of code in Excel I would extend it to run a FM import script.

Careful when you do that: a FM script triggered from the outside *will* interfere with any scripts you may be running manually in the file on the same machine.