Excel Worksheet/Graph

Hi All,

I need to be able to access and place values in a worksheet that is placed on a form. From this I need create a graph on the data. BUT HOW!!

I don't want to open Excel from VB6, just access the worksheet.

I've tried everything and it's driving me MAD. Surely it can't be that difficult, or is it.

Please help.

Dave R.

Dave,

Welcome to vbf.

by accessing the worksheet do you mean one that has been included as an OLE Object?

Moved from ClassicVb

Hack,

I think this is actually VB6 using a OLE embedded spreadsheet..

Hi Danny,

What I've done is 'Right-Click' on the 'General Tool Bar' and use 'Components/Insertable Objects' to be able to get the Excel Graph and place this item on a form in the same way as other objects. This includes a sreadheet and graph sheet already with data

I tried to place values into the spreadsheet using:

Graph1.Sheet1.cells(1,1)=12

and other similar calls, but I keep getting error messages. If I deliberatly place values I can then probagate a graph, but I need to put values from equations in there.

I'm pretty new to VB of any level, only being a Turbo Basic programmer with limited experience.

Rgds,
Dave R.

P.S. Well done in the cricket, but we let you win, only kidding I'm a Aussie/Pom since 1982