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

Click here to load this message in the networking platform