Thanks Glen,
Makes sense to me. The app doesn't use any excel functionality outside
of reading cells so I should have no problem with the excel 97 library.
Ryan
"Glen Albert" wrote in message
news:5E7B7BB7377C83B3E63500785C8E382F@in.WebX.maYIadrTaRb...
> I have no experience with excel, but in general you need to use the older
version (you can't reference both as they use the same object names).
>
> Typically what happens is the newer version of an object library has
additional objects/properties/methods that don't exist in the older version.
If you are using any new features of the excel2000 object library (you will
discover this when you reference the old version then Compile your program),
you will either need to rewrite your program to work without these features,
or not support excel 97, or you will need to create two versions of your
program.
>
> Glen
> "rsmall" wrote in message
news:f05912b.-1@WebX.maYIadrTaRb...
> I've written a routine that utilizes excel. Some users will have excel97
installed and others (like myself) have excel2000. Because I have office2000
on my system, the only reference that I have set is for excel2000. Users
that are using excel 97 have been experiencing difficulty running the
appplication. If I want my routine to be used seamlessly regardless of excel
version is it as simple as setting a reference to both excel 97 and 2000?
>
