Re: Excel Worksheet/Graph
Dave,
Welcome to vbf.
by accessing the worksheet do you mean one that has been included as an OLE Object?
Re: Excel Worksheet/Graph
Re: Excel Worksheet/Graph
Hack,
I think this is actually VB6 using a OLE embedded spreadsheet..
Re: Excel Worksheet/Graph
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