My article on Excel Automation includes a simple example:
http://www.utmag.com/ViewPageArticle.aspx?Session=71636C35633061317766733D206436645768706D6378776175663557323570506D71673D3DHTH,
Hilmar.
>Hi friend!
>
>I'm using Excel OLE automation to create a chart whose data source is in a worksheet. I need to create a chart in the same sheet as the data is. How can I do it? I used the Add() method of the charts class but it creates a new chart as a new sheet, I don't want that. I want to have the chart incrusted in a sheet.
>
>Any hepl would be very appreciated.
>
>TIA
>
>Luis Guerra
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)