Open excel file

[DanBrill]

Hi,

I'd like to create a script that opens a file in MS excel. (Using FM 6 Developer and Win XP). I think that this requires a DDE command. But I'm not sure. And if so, I have no idea what that command is. Can anyone help out? Where should I go to find a listing of DDE commands for other applications.

Thanks for any suggestions,

Dan

[RussBaker]

Not too sure exactly what you want to achieve here - but in Windows you can create a container field, link an excel document to that container (or embed it in the file) using the Insert-Object Menu. Select it to show as an icon, then script a button to Go to Field[select/perform] and the document will open in its parent application.

I use this a lot when providing template type files if data is going to be collected in something other than Filemaker (Excel is the usual culprit).

[DanBrill]

Thanks. That's a lot simpler than what I was thinking of.

Dan