Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Graphing with 2 axes
Message
From
22/01/2005 10:38:00
 
 
To
22/01/2005 10:07:24
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00979581
Message ID:
00979586
Views:
16
One thing that may help is to use the proper value for xlBuiltin. When I pull up Excel and hit Alt-F11, then F2, I see that xlBuiltin has a value of 21 not 0. I did not go any further but this should be of some benefit.

>Hi all
>
>I 've tried automating the following VBA code in VFP7 with OLE error
>
>ActiveChart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:= "Line - Column on 2 Axes"
>
>My VFP Code is :
>
>MyClass.oExcel.ActiveChart.ApplyCustomType(0,"Line - Column on 2 Axes")
>
>Would greatly appreciate if you could point out my error.
>
>Thanks & Best Regards
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform