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!

You're about to enter the zone known as DLL Hell! Obviously, Excel 97 doesn't have access to the XP DLLs, so it will complain mightily about missing components or 'project or library not found' and highlight something daft like Left(...) as the culprit. Unless you have a copy of 97 lying around, you will have to take you app to the client, and re-link the references to the Excel 8.0 library. Also check that you're not using any other Office libraries later than 8. If you're lucky, you will not have used any ver. 10 specific code, and everything will run happily, otherwise you will have learned a most valuable lesson:-
when developing, always use the same version of Office as the client will use in production!



There are two secrets to success in this world:
1. Never tell everything you know

Thanx for the reply!!..

 One last Question (porbably not the last).. Is it possible two have two versions of office apps in one comp?.

LION OF JUDDAH!

When installing oXP you're asked if you want to keep any prior version of o on your pc.

Other way round, be sure to install into another library than the one occupied already by oXP/2k. Worked for me except for an error not granting me the rights to use o97. Installing the font 'Haettensweiler' solved that problem. Don't know why, though. Read about it in a forum.