>We have a standard excel template which needs to be populated with data. The data is held in a number of foxpro tables. Therefore what I would like is for the user to click a macro within the excel document which will invoke my foxpro application. From this it will prompt the user for a particular record when they click ok the data will be imported onto a new sheet in the original excel document. From here I then use this data on my excel sheet.
>
>Does anybody know how best to do this. The foxpro side is pretty easy its the invoking the excel exectuable and importing the data within a new sheet that I am unfamliar with. Any help would be really appreciated
>
>Many Thanks
I personally like to open and control Excel from VFP. See
http://www.utmag.com/wconnect/wc.dll?9,7,10,1562 for an introduction of "Excel Automation".
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)