Aaron Scott-Boddendijk wrote:
>
> > //...
>
> How do you deal with the situation where a customer may not have
> the *.olb files registered. I haven't had any luck registering them
> manually... [This is said with a very large 'not an OLE expert' hat on]
( I've got one of those hats too... )
We pretty much took the attitude that we could write software that would
work if Excel was installed correctly, and asserted that installing
Excel correctly meant OLE would work (I can't think of any detail of
what constitutes a standard Excel install now though. Question for your
System Admin?). Otherwise there is a Massive amount of ground to cover,
eg. if they aren't registered, what if they aren't in the correct dir?
Not on the machine? Old versions? Later versions? Dependencies? ...
Note however: with pretty much one client, we probably could have got
someone on to the machine to re-install Excel etc. if we needed to, this
mightn't apply to you...
>
> > ASHT := ER.OLEExcel.ActiveWorkbook.ActiveSheet;
> > xlRange := ASHT.Range[ 'A1', 'H8'];
>
> This statement seems fine... For some reason the variant array access
> doesn't behave the same between Word and Excel for collections... Bizarre...
I think there are even different methods within Excel... Visual Basic...
>
> I'm sure Michael will inform you all of his results... Shame that OLE doesn't
> provide the same reflection support as Java ('almost' bug-free and
> complete)... It's not like OLE is ay faster ;)
>
> Ah well...
>
> --
> Aaron Scott-Boddendijk
> Jump Productions
> (07) 838-3371 Voice
> (07) 838-3372 Fax
>
> ---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
--
_______________________________________________________________________
Kurt Wilkin Phone: (+64 4) 473 1480
OO Developer Fax: (+64 4) 473 1515
ACT Financial Systems,
Level 10, Dalmuir House, 114 The Terrace.
PO Box 10_278, Wellington. email: [EMAIL PROTECTED]
***********************************************************************
This communication is confidential to ACT Financial Systems (Asia
Pacific) and is intended for use only by the addressee. The views
and opinions expressed in this email are the senders own and do not
represent the views and opinions of ACT Financial Systems (Asia
Pacific).
***********************************************************************
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
