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

A

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
 
T

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).
 
A

Andy Shen

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

Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top