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

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

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

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

--
Regards,
Tom Ogilvy

"Andy Shen" wrote:

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

Compilation error when using an English VB program on a French
 

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

Andy

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy

"Andy Shen" wrote:

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