Compilation error when using an English VB program on a French Exc

[Andy Shen]

Hi there,

I have written a English VB program for US version of Excel to do several
calculations. The calculation requires to use the Solver, therefore there is
a reference to Solver.XLA. I email the spreadsheet to a colleague in
Swizterland, who is using a French version of Excel. When he first ran the
program, Excel gave a compilation error: Project or library not found. I
have no idea where this can come from.

Looking at his screen shot, I recognize the only difference in the Project
window is a EUROTOOL.XLA loaded in his version of Excel. I don't know the
solution to this and therefore I am posting this question here and hoping
someone can give me a hand. Thanks in advance.

Andy

 

[Tom Ogilvy]

does he have a reference to the Solver Addin in Tools=>References?

Is it broken

(After the error, go into tools=>References in the VBE with your workbook as
the active project. See if any references are marked as MISSING. If so,
these need to be fixed).

 

[Andy Shen]

Thanks, Tom. I will check with my colleague and will come back her if we
found other problem.

Andy