Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Printing Msgraph
Message
From
10/04/2001 06:00:09
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
09/04/2001 14:37:00
Scott Barker
Barker Systems Consulting Ltd.
North Vancouver, British Columbia, Canada
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Miscellaneous
Thread ID:
00493112
Message ID:
00493944
Views:
25
Pardon me for jumping in.
Scott,
You can find object model for MSGraph5 and up. Search for a file named vba_grp*.*. For MSGraph5 as far as I remember name was different and was located in MSGraph dir. Later versions seem to be located under Office dir (and as I remember during install VBA help is optional).
For your problem syntax would be :

myform.myGraph.object.application.datasheet

However I think this is related with your web chart problem. IMHO Excel is way better and faster than MSGraph. MSGraph9 and up has PEM almost identical to Excel's. So if your version is 9+ you could simply use Excel developer help too.
As another side note if you would use MSGraph instead of datasheet use code like :
#DEFINE TAB_ CHR(9)
#DEFINE CRLF CHR(13)+CHR(10)
* Data prepare *
wait window nowait "Filling cell values..."
MCGDATA = ""
nCols = fcount()
for ix = 1 to nCols
  MCGDATA = MCGDATA + iif(empty(MCGDATA),"",TAB_)+field(ix)
endfor
MCGDATA = MCGDATA + CRLF
scan
  for ix = 1 to nCols
    MCGDATA = MCGDATA + iif(ix=1,"",TAB)+nvl(transform(evaluate(field(ix))),"")
  endfor
  MCGDATA = MCGDATA + CRLF
endscan
* Data prepare *

create cursor testgen (genfld1 g)
append blank
append general genfld1 class "msgraph" data MCGDATA
Filling cell values using datasheet is much slower.
Cetin

>Hi Vlad.
>
>I'm intereted in your approach on this for msgraph and can get the oleboundcontrol working on the form ok. I'm having a little trouble seeing down into the object model ... just looked at it with the debugger.
>
>Is there a help file for the model that you know of?
>
>form.oleboundcontrol.object.datasheet returns the error unknown name ... so, I don't have the model path correct.
>
>... could you provide a couple of lines so that I can get this right?
>
>Thx, Scott :-D
>
>ps; To save the graph to a file ... I've been shown that the Export method works well for this: object.Export("filename.gif","GIF") .. nicely creates a GIF file of the graph.
>
Ç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
Previous
Reply
Map
View

Click here to load this message in the networking platform