Great.
The other important point - mentioned in another reply you got is this: for any work you need done in Excel, just save a macro in Excel, and look at the code. You will need to adapt the code, but most of the commands are right there, in the saved macro.
>Thank you Hilmar,
>
>Your article gave the solution I was looking for. It is the Location method of the chart object.
>
>Thank you ver much.
>
>Luis
>
>
>>My article on Excel Automation includes a simple example:
http://www.utmag.com/September2002/Page45.asp>>
>>HTH,
>>
>>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)
