[Marvinq]

very urgent, I need to be able to update msgraph.chart.8, also called
Microsoft Graph 2000 in visual basic. All of my efforts have failed.
I've searched the internet and found some references to using the
datasheet.range properties, but VB just gives me errors.

I've heard this can work with OLE. My backend is SQL. I need to
pass the query results to the chart somehow.

Can any of you geniuses out there show me a way to make it work?

Thanks
Marvin

Archived from group: microsoft>public>vb>ole

[Steve Rindsberg]

In article , Marvinq
wrote:
> very urgent, I need to be able to update msgraph.chart.8, also called
> Microsoft Graph 2000 in visual basic. All of my efforts have failed.
> I've searched the internet and found some references to using the
> datasheet.range properties, but VB just gives me errors.
>
> I've heard this can work with OLE. My backend is SQL. I need to
> pass the query results to the chart somehow.

What chart, where?

MSGraph isn't a standalone app; its charts have to be hosted in another app --
Word, PowerPoint, even Wordpad. And to get AT the embedded chart, the app
would have to expose automation, so WordPad would be a nonstarter.

To pass data to a chart, you'd need to get a reference to the chart object in
the host document and through it, get access to MSGraph's methods/properties in
order to manipulate the chart.

Hint: get it working with Excel charts, then translate to MSGraph. The object
models are quite similar.

--
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================