Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Graphing in Excel
Message
 
To
16/11/2004 16:13:01
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP1
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00961925
Message ID:
00961996
Views:
13
Here are some:
#define xlNormal -4143
#define xlMaximized -4137
#define xlLine 4 && Line Graph
#define xl3DLine -4101
#define xl3DColumn -4100
#define xlColumnClustered 51
#define xlColumns 2 && Data source by columns
#define xlLocationAsObject 2
#define xlCategory 1 && Axis
#define xlLandscape 2
#define xlPrimary 1
#define xlPaperLetter 1
#define xlValue 2
#define xlTrue -1
#define xlFalse 0
#define xlUnderLineStyleNone -4142
#define xlAutomatic -4105
#define xlUpward -4171
#define xlCenter -4108
#define xlThin 2
#define xlThick 4
#define xlMedium -4138
#define xlContinuous 1
#define xlSeries 3
#define xlSolid 1
#define msoGradientHorizontal 1
#define msoGradientVertical 2
#define msoGradientFromCenter 7

I'll check for an INCLUDE file an mail it to you. You might be able to google it from MSDN support sites.

Have you searched your desktop for .H files?


>Hi all
>
>I'm using VFP7 to draw a graph in Excel. I have recorded the macro to plot a graph. When viewing the macro script, I notice some variables that are used in the script such as :
>
>xl3DColumnClustered
>xlLocationAsObject
>xlColumns
>xlCategory
>xlSeries
>
xlValue
>
>As I need to write the VFP code to perform the equivalent of my macro script, I would appreciate if you could point me where to lookup the domain values for each of the above variables.
>
>BTW, is there a way for VFP to execute a Excel macro from within VFP?
>
>Thanks
>
>Best Regards
Imagination is more important than knowledge
Previous
Reply
Map
View

Click here to load this message in the networking platform