Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 1st 05, 11:16 AM
 
Posts: n/a
Default 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   Report Post  
Old July 1st 05, 11:31 AM
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Old July 1st 05, 05:06 PM
rg1117
 
Posts: n/a
Default

Hi Bob,

Thanks for your reply. I will try to follow the suggestions.

Thanks,

RG

  #4   Report Post  
Old July 2nd 05, 08:35 PM
Jon Peltier
 
Posts: n/a
Default

Last year I encountered great difficulty when using Solver through VBA.
The problem was pronounced when a workbook was used on different
computers with different versions of Office and Solver. While trying to
fix everything, I learned all about how add-ins are supposed to work,
how to install and uninstall ad-ins and set references to them through
VBA. I also learned that Solver really doesn't follow the rules.

Ultimately I had to resort to using Application.Run to accomplish the
task. While inelegant, it was very robust compared to trying to use the
"official" procedures. Here is a short example (watch line wrap in the
second line):

Application.Run "solver.xla!solverreset"
Application.Run "solver.xla!solverok", "Output", 1, , "Input1,Input2"
Application.Run "solver.xla!solveradd", "Input1", 1, 12
Application.Run "solver.xla!solveradd", "Input2", 1, 7
TestSolver = Application.Run("solver.xla!solversolve", True)
Application.Run "solver.xla!solverfinish"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


wrote:

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
External Links on open and Excel 2003 Guardian Excel Discussion (Misc queries) 3 June 16th 05 12:25 AM
Help in Excel 2003 Charlie Rowe Excel Discussion (Misc queries) 0 June 13th 05 04:31 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 03:44 AM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM


All times are GMT +1. The time now is 04:58 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017