Transmitting data from a formula into excel

[Mark Rockley]

I have written a weird kind of efs formula and I would really like to process the output from that formula using EXCEL. Moreover, while it is trivial to export the data to excel by a manual operation, is there any way to achieve this feat dynamically so that the EXCEL spreadsheet is constantly updating. Thanks. This is a GREAT bulletin board.

[ACM]

Re: Reply to post 'Transmitting data from a formula into excel'

Mark
If you want to export the contents of a chart on a "snapshot" basis then
right click the chart and from the context menu select Tools->Data Export...
This will give you a tabular view of all the data and indicators in that
chart. Select the columns you want to export and save as csv file.
Alex

[ckryza]

Mark:

In addition to the approach that Alexis describes, you could also use the FILE object available within EFS to write the results of your custom calculation to a text file (formatted however you want) at regular intervals. Then, I presume that you could use the VBScript within Excel to to force your Excel app to reload this data file if it notices that the file time stamp has changed.

Chris