Hi Charles. Do a search on the UT for "DDE EXCEL" there are some code sample going back over the last few years.

>I am enhancing an old APP that has a DDE link with EXCEL.
>I am using Foxpro to load data columns into EXCEL and then use Excels Charting function to produce a graph. The construction of the chart and its customizations are done via an EXCEL Macro.
>
>
>I would like to
>
>1. Have the macro execute once Foxpro has posted the data
>
>2. Switch from one Worksheet to another within the same workbook.
>
>
>Can anybody give me some design advice here?
>
>Future conversion to VFP is too far off to postpone this enhancement.
>
>
>Thank You for any help you can give me...