>Hi,all
> Today,a problem is coming to me.Can you help me?
> I want to make datas in dbf to display the processing
>graph without user's any selections. I ever try to use
>'WZGRAPH',but I don't know the meanings of the parameters and it's effect is not good.
> I want to use DDE between VFP and EXCEL. But I don't
>know how to write the program. can you tell me how to do
>it? An example program is welcome!
> Thank in avidance!
you can use OLE to work with Excel instead of DDE (much better IMHO)
e.g.
oExcel=CreateObject("Excel.application")
oExcel.visible=.f.
oExcel.windowstate=1
oExcel.workbooks.add
for i=1 to 10
oExcel.cells(i,1)=mydata.data
endfor
oExcel.Range("A1:J1").Select
oExcel.ActiveSheet.ChartObjects.Add(159.75, 82.5, 292.5, 156).Select
etc.etc.
arnon
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only