Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Add-In causes excel 2003 to crash on startup
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 |
#2
|
|||
|
|||
The only thing I could find in the KB is this article, which doesn't
actually address your problem The Solver add-in may not work or does not find a solution in Excel 2003 http://support.microsoft.com/default...b;en-us;819033 It does suggest a Solver upgrade though, so you might try that route. -- HTH Bob Phillips wrote in message ups.com... 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 |
#3
|
|||
|
|||
Hi Bob,
Thanks for your reply. I will try to follow the suggestions. Thanks, RG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
Help in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |