VBA with OLE Excel Automation

[BuskyLusky]

Hi.
I have some problem writing my own values to an Excel Ole Object. I add an OLE object, then selects MicroSoft Office Excel Chart. Then an example chart is shown. I wish to edit this one to use my own data, which I may extract from the VBA form. If you try to edit the excel object by right clicking it, you may manually change the chart data. I want the object to automaticly read values from the VBA form, then use these data to draw the chart. Is there any one who can help me with this?

Thanks in advance
BuskyLusky

 

[SkipVought]

Hi,

What code are you having trouble with?

Skip,

_[red][/red]