 |  |  |  |  |  |  |  |
insert data in the Sheet of an OLE Chart
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
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.
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.
|
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Data Extraction
- Next Thread: open a NON specific type file
Views: 984 | Replies: 0
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp c++ calculator cd cells.find click client code college column connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver struct subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window
