Microsoft Excel 9.0 Object Library
hysterio
Jan Hyde
thoughts were released on Fri, 6 Jan 2006 00:11:23 +0100
bearing the following fruit:
You should have a compile machine that has the lowest
version of OS, and software you intend you product to work
with. Then you should have no such issues.
Jan Hyde (VB MVP)
--
If you like meeting new people, you should become a Midwife!
hysterio
news:r6dsr1hunc43ustat...@4ax.com...
I do know that, but i don't have the money to buy all office versions that
are released. So this is just for a program that i'm writing voluntary for
some friends that have a club where young people can meet
Richard Jalbert
<hysterio200...@hotmail.com> wrote:
>Hi,
>
>When i look in my Project - References window i see "Microsoft Excel =
>10.0 Object Library", because i use Office XP Professional.
>The program i'm writing has to run on a pc with "Microsoft Excel 9.0 =
>Object Library" (Office 2000). Is there any possibility to add the 9.0 =
>Object Library to the list, so i can select it and compile the program, =
>without installing Office 2000 on my pc ?
>Because when i run it with the 10.0 Object Library on the pc with office =
>2000 it crashes
>
>Greetz
>and many thanks!
>hysterio
You should develop any software on the lowest OS that it is advertised
to work on...and a thing we found out while developing a commercial
applciation:
develop using the oldest library of the sofware that will be called.
In that case, if you could get the library for Excel 97, it would be
the ideal. I think they can be downloaded from MS sites.
But for that to work, you need to code with early binding (for the dot
operator to work) then compile with late binding so other, higher,
versions won't crash your program.
**********************************************************************
Rich...@sympatico.ca
Dog thinks: they feed me, they take care of me: they are gods.
Cat thinks: they feed me, they take care of me: I am god.
http://www3.sympatico.ca/richmann/
http://www.geocities.com/richmannsoft/
**********************************************************************
hysterio
checked the website of microsoft, and searched on "object library excel
download" but couldn't find any link to download.
so i guess i have to come up with something else.
--
Groetjes,
Roel De Nijs
Voorjaarstraat 27
2610 Antwerpen
"Richard Jalbert" <rich...@sympatico.ca> schreef in bericht
news:43beb7d1...@news1.qc.sympatico.ca...
MikeD
"hysterio" <hysterio200...@hotmail.com> wrote in message
news:%23tgTRlx...@TK2MSFTNGP11.phx.gbl...
> this is not a commercial program, so its just for a friend of mine. i
> checked the website of microsoft, and searched on "object library excel
> download" but couldn't find any link to download.
>
You're not going to find it. It's not downloadable from MS (or anywhere
else, at least not legally).
As has been mentioned, the "best" thing to do is develop with the lowest
version you need to support. But many times, this isn't always possible or
practicle for any number of reasons.
Theoretically, you *can* develop your app using early-binding and a later
version (such as you using the Excel 10 object library) and it will run just
fine with an older version of Excel. The object libraries for all versions
of Excel are binary compatible (meaning the GUIDs for objects are the same).
However, you must be VERY, VERY careful that you don't use features found in
later versions of Excel that don't exist in the earlier versions. For
example, the object library for Excel 10 might have objects, properties, or
methods that don't exist in the object library for Excel 9. If you use any
of those, your app's not going to run with that older version of Excel
(you'll always get some kind of runtime error). This is why it's recommended
you use the lowest version you need to support because that eliminates any
chance of using a feature found only in a later version.
Bottom line is that if you develop with a later version of Excel and your
app needs to work with an earlier version of Excel, YOU have to be
absolutely 100% sure you're not using objects, properties, methods, etc.
found only in the later version. Practically speaking, that's not
necessarily so easy to do. The best thing you can ultimately do is have
your program thoroughly tested by users having an older version of Excel if
you can't do so yourself (and it's always best to have others do testing
anyway because they're always going to find bugs that you won't).
--
Mike
Microsoft MVP Visual Basic
P.S.
By any chance, did you also ask about this in general.discussion under the
name Vanny? I'm just asking because it's remarkably similar. If so, don't do
that in the future. Multiposting using the identical subject and name is
bad enough, but when you use a different subject and post under a different
name, it's 10000x worse.
Richard Jalbert
<hysterio200...@hotmail.com> wrote:
>Hi,
>
>When i look in my Project - References window i see "Microsoft Excel =
>10.0 Object Library", because i use Office XP Professional.
>The program i'm writing has to run on a pc with "Microsoft Excel 9.0 =
>Object Library" (Office 2000). Is there any possibility to add the 9.0 =
>Object Library to the list, so i can select it and compile the program, =
>without installing Office 2000 on my pc ?
>Because when i run it with the 10.0 Object Library on the pc with office =
>2000 it crashes
>
>Greetz
>and many thanks!
>hysterio
Do you have a valid e-mail. I tried sending something to you and the
address was no good.