Cindy
Mon Oct 09 04:11:29 CDT 2006
Hi Vbnetdev,
> Anyway, I have a dataset filled with data and need to populate an MS word
> chart with it. Any tutorials or suggestions would be great. I know a dataset
> is a .NET concept but taking the chance people here might be familar with
> it.
>
I'm familiar with it...
First thing you have to decide is whether to use an Excel chart or MS Graph.
Both use the same "engine", but with Excel the data is embedded on a
spreadsheet in the OLE object, while with MS Graph you fill a "data sheet". MS
Graph also has a more limited object model; OTOH, the machine where you're
creating the chart doesn't have to have Excel installed.
On my website you'll find a bit of VBA code that illustrates how to generate a
chart from a set of data as part of a mail merge. This should give you the
basics for automating MS Graph. If you need more assistance, the better place
to get help would be the office.developer.automation newsgroup.
Http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#MrgChart
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)