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...