Guyz, i got this program am developing in VB6 but generates reports using excel en at work we are using Office XP but the client uses Office 97. I do have a reference on my VB6 project to "Microsoft Excel 10.0 object library" the program generates reports fine on office XP machine. Am wondering if this can still work on the clients computer who are using office 97. If i can't use this is there any suggestions?.

Please help!!!

LION OF JUDDAH!

__________________
LION OF JUDDAH!

I don't think that it'll work when you use the reference of XP. You should refer to 97 typelib. To do that, copy the file Excel8.OLB locate in the Office folder on the client computer to your computer. After that register the typelib using regtlib. You should now be able to refer to Microsoft Excel 8.0 object library.

PS: I'm not a 100% sure that the file is name Excel8.OLB. If you don't find that file, search for the file Excel*.OLB and use the file that you find.

Stéphane Lajoie

I think am jus gonna have to use office 97 because DLL's will be different (unless it was the other way around CLient using XP and am using 97).
Another Question though is it possible to have 2 different Office Apps on one Comp? (office XP and Office 97)

This goes to Stéphane Lajoie.. the program u were helpin me with worked out well at the end thanx for the help.

LION OF JUDDAH!

Hey buddy.. I would like to try what u were saying (registering the .olb).. am sure if it works it will come in very handy one day.

I would like to to ask though if i include XL5EN32 (The EXCEL8.OLB version of XP...am not sure but i would bet it is)... if i include XL5EN32.OLB in my Setup file would it register it at the clients computer.

Have u ever tried this (registering the .OLB files before)?

LION OF JUDDAH!

I've just look at the library XL5EN32.OLB. With this library, your application will be compatible with Excel 95 and later.

I'm not a 100% sure, but if I remember correctly, you don't need to redistribute this file, you only need it for the compilation and building of your app.

Stéphane Lajoie

Do u think it would work if i register the EXCEL8.OLB in my XP machine that am doing the designing on en try to use it's references??.. Hope i make sence..

LION OF JUDDAH!

Hey don't worry what i was askin b4... I din't get that. I jus realised waht u meant. thanks for that.

LION OF JUDDAH!

Look for Excel.exe instead of Excel.olb for office 2002.

Hi there,

I am having the same problem here, but not sure on how to regiter the typelib using regtlib.

How do I go about that?

Thanks!!
AWoo.