Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ChartType command
Message
De
24/10/2002 06:04:54
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
24/10/2002 05:50:40
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00714723
Message ID:
00714729
Vues:
23
>Hi All,
>
>Any idea of how I can change the ChartType on my form. I have looked into the help file vbaxl9.chm and there is a whole list of charts I can create.
>
>The problem is that they expect you to code something like:
>.ChartType = xlBubble, but this does not work in VFP.
>I have tried to code:
>.ChartType = somenumber and this works, but how can I find the corresponding numbers in VFP? When I tried to change numbers, some of them produce an error message.
>
>Or maybe there is another way to do that?
>
>Appreciating your help.
>
>Jonathan

Jonathan,
xlBubble is a defiend constant numeric value. You could use it :

#define xlBubble 15

.ChartType = xlBubble

I think there were all excel constants here in downloads section or at John Harvey's (www.johnharvey.com ?) site.

If you have VFP7, you could get all constants using object browser (add excel type library, drag&drop enumeration group from enums node).
Also w/o using object browser intellisense would help :

LOCAL oExcel as Excel.Application
oExcel =CREATEOBJECT('Excel.Application')
*...
oExcel.ActiveWorkbook.ActiveChart.ChartType=

as you press [=] intellisense would pop a listbox showing all available charttypes to select.

You could also get constants with west-wind utility (wwGetConstants ?)

If none of the above work. Launch excel :
[Alt+F11], [F2], write xlBubble [enter]. You'd see the whole group and below listboxes actual numeric value.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform