>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
Hi,arnon
Thank you for your help. My two PC had already installed EXCELL 5.0. One is running in WIN3.1,the other is running in WIN95. I use your program to run in WIN95 but it cause an error which show "Class definition EXCEL.APPLICATION is not found". When I run it in WIN3.1, it also cause an error. it's error message is "OLE error code 0x80040154 class not registered". I think EXCEL must be not registered .
Then I try to register EXCEL with OCX in VFP. I select "Tools/Options" menu and select "Controls tab".then I choose OLE to select OCX file in windows/system. But there are only two OCX Files (MSOUTL32.OCX, PICCLP32.OCX) in PC "A" which eviroment is WIN3.1. I try to add each
other, but the error is still exit! I am in great trouble now!
So, how to solve the error?
If I build EXE file, Which files such as OCX files are needed? Does EXCEL 5.0 must be install in every PC in which I setup my EXE file?
Thanks&Regards
Kevin
Kevin Wang
Programmer&Analyst
Ministry of Water Resources
No.1,Baiguang Road
Beijing,China