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)
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
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.
>