COM object problem

[QatQat]

Hi There,

I have created a ActiveX DLL that generates invoices in .xls format on the server using an invoice template.
In VB6 I have a reference to "microsoft excel 10.0 object library" and, when compiled and registered, the DLL works perfectly on the server where Office 10 (office 2002) is installed but it does not work on any other server using different version of office.

Is there a way to avoid this compatibility issues?

Thanks


QatQat

Life is what happens when you are making other plans.

 

[kav123]

When you say it does not work on any other server, or a different version of office, do you mean older version or newer version. Try referencing to Microsoft excel version 11.0, and then see, if it is backward compatible, since version 11.0 is the latest version.

 

[Sheco]

Referenced libraries are also known as dependencies.

 

[QatQat]

Well, I only can reference libraries corresponding to the version of office installed on the PC where VB6 is installed. I tried to install two versions (2002 and 2003 so library 10 and 11) and it just shows the latter.

A solution would be to compile different .dll related to different environments but I do not find it a neat solution.

One would think that Excel library 11 was backward compatible...but not when it comes to Microsoft.


Thanks guys

QatQat

Life is what happens when you are making other plans.