Quoting Michael Switzer <[EMAIL PROTECTED]>:
> Thanks for your reply Patrick,
>
> But if I read your code rightly, you've got methods for reading, writing
> and
> clearing an Excel cell. What I am looking for is a way to return a *Range
> Object* from the cells that have been written into ...
My recollection was we would have tried to use a Range object in order to clear
cells, but we couldn't do that.
> Once I've pumped the data into Excel, I need to convert that data into an
> Excel Chart. Excel requires a Range Object to identify which cells to use
> to create the chart. I'm expecting the code to look something like
>
> ASHT := ER.OLEExcel.ActiveWorkbook.ActiveSheet;
> RNGE := ASHT.Range(ASHT.Range.Cells(1,1), ASHT.Range.Cells(10,1)).Select;
>
> (where ASHT and RNGE are of type OLEVariant) Except that this does not work
> so maybe it looks quite different. :-)
>
> So do you have any further pointers?
The chart we are using is predefined - when the cells are filled in it
automatically updates.
Does your client have a specific reason for wanting to use Excel or could you
achieve the same thing more readily using TeeChart?
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
