Mark Howard wrote:
> I'm trying to upgrade from D5 to D7
>
> I have a bit in my app that writes data out to an Excel file (virtually
straight out of
> Marco Cantu's book)
>
> It had a declaration
> RangeE: Excel97.Range
> which I have changed to
> RangeE: Excel2000.Range
> but it is complaining 'Undeclared indentifier. Range'
>
> So, it seems that they have changed the name of Range to something else.
>
> Has anyone found this and know the answer, or can someone tell me where I
can
> find documentation on the Server components, please.
First and simplest (if it works) Excel 2000 probably implements the Excel8
(i.e. 97) interfaces as well as the newer ones, so you may not need to
change your code, provided Delphi 7 includes a unit defining the old
interface (or you build one yourself either from the Delphi 5 unit or or
from the type library).
Failing that, look at the unit defining "Excel2000". The "Range" object (if
there is still such a thing) may have to be called "Range_" or something
like that in Delphi.
In any case, to find the object model, in Office 97 you start up the visual
basic editor from the macros menu in Excel and use the object browser and
the associated help files. With any luck there's something similar for
Office 2000, although it may not be installed by default.
The info is probably somewhere on the Microsoft site, too, but it'll be
cunningly concealed behind all the .NET and XML toys that they'll push at
you instead.
Regards,
Brian
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
