>>We would like open an Excel spreadsheet, populate it with data from a MySql backend, then manipulate and save that data. The preference is that this be done inside the VFP application with a link to Excel through an ActiveX (or some other) control rather than opening a new instance of Excel.
>>
>>Could anybody point me some code samples, documentation, etc. on how to do this?
>>
>>Thanks to all.............Rich
>
>In any case you will need to open Excel. One of the solutions is to put excel window inside VFP form.
>For instance, see example here:
>
http://www.foxite.com/archives/0000230515.htm >
>
>Good Luck
Yuri:
Thanks for the help. It should be very useful for me. I have an additional question that I hope you can help me with.
thisform.oExcel = CREATEOBJECT("excel.application")
thisform.oExcel.displayalerts = .F.
Thisform.oExcelWindowHandle = FindWindowA(NULL, thisform.oExcel.Name)
SetParent(Thisform.oExcelWindowHandle,thisform.HWnd)
Is there any way to have it be part of a Page in a Pageframe object? There's no HWnd property (at least I didn't find one) for either the PageFrame or the Page. Is there any equivalent that I can use?
Thanks again. Your help is always appreciated.
.........Rich