Hi all,

I have a question regarding Microsoft Excel, VBA and add-ins. The story
is as follows.

We have developed an Excel Add-In using VBA, initially in Excel 2000.
They were working fine until the computers were upgraded to Office 2003
(Company IT policy, no choice about it). They stopped working, as some
libraries which were referenced by the VBA code changed location.

Specifically, it was the Microsoft Office Web Components and the
Solver.xla. We managed to find the new locations of these files and
changed the references to match these new locations. Next we recreated
the add-ins (.xla file) from the developer version (.xls file).

The problem now is that when we install the add-in into excel 2003, it
crashes on startup. The strange thing is the .xls version works
perfectly and carries out all the functions correctly without crashing,
but the .xla version does not.

I have been able to pinpoint that it is specifically the solver
reference that causes the crash. I know this because when I create the
add-in without a reference to solver, it loads fine (though it
obviously cannot execute any functions that need solver.)

Can anyone offer me an explanation of what is going wrong. I would
appreciate any help.

Thank You in advance,

RG