Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Graph? VFP --- DDE---- EXCEL ?
Message
From
10/01/1997 07:16:20
 
 
To
10/01/1997 04:00:24
Kevin Wang
Ministry of Water Resources
Beijing, China
General information
Forum:
Visual FoxPro
Category:
User groups
Miscellaneous
Thread ID:
00016994
Message ID:
00017000
Views:
95
>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
Map
View

Click here to load this message in the networking platform