Hi, people!
I need some help with OLE in vb.
I need XY Scatter Chart in vb, but there is no way to get it, so I found OLE and with this application I'm able to get this type of Chart. The point is that I don't know how to use it!!! I found out that pushing right button and going to Edit, a sheet of Excel is opened and I can change the data and so, it changes the curves of the chart.
But what I want is to be able to change this data from this sheet when the program is running. I mean, I want to run the program, insert some data, and with this data the program will do some maths and get some values, and those values are the ones that I need to insert in this OLE sheet.
Do you know how can I make this??
I need something like this:
Frm1.OLE1.Sheet1.cells(1,2)=38
Frm1.OLE1.Sheet1.cells(2,2)=42
This doen't exist but I need something similar. Any help? Any idea?
Thank you very much,
Maria.