>Hi Everybody!
>
>I read a thread about MSGRAPH. I use it for a while, and I have a problem, that how to determine the numeric constants, like xlNone, xlDouble, xlSingle and so on. Till now, I used to write a VB program, assigning these constants to variables, and saw in the debugger, but it is very inconvient, at everytime. (The properties and methods are in vba_gr.hlp)
>Does know anybody a source, where all the constants are available?
>
>BB
Hi Bela,
Wellcome back. VFP says that constants are in .bas files that come with Office SDK if you ever have the SDK. Also on microsoft site it should be somewhere (I do this assumption for at least there is one for word constants). Now I have extracted all constants for only xlChartType (can post or here see thread "Graphs in VFP5"-07/16/1998, 22:06:10). I have a painfull way to get what I need :
-Open excel (or word, pp, any office component)
-Select tools\Macros\VB editor
-Press F2 (Object browser launches)
-Find xl* in left window (ie:xlChartType - parent for the member you're seeking)
-Click on member in right window (ie: xl3dArea)
-Value displayed in hex and dec beneath the windows.
If I ever was a VB programmer I would write a code to export all those constants (maybe F2-Object browser supports OLE ? for a go get from VFP).
Cetin