Dear Jon,
thank you very much for this esplendid and impressive web site you have created.
It is awesome indeed! I am quite new at excel macros and VBA (after some time dedicated to C++ and other environments), but I have seen that for the students this is an easier way to get into grips with programming. I have discovered the Solver Add-in not so long ago but I have found something weird I think. I follow the instructions that you give at
http://peltiertech.com/Excel/SolverVBA.html
but when you say “[...] In addition, the Solver library will be accessible through the VB Editor’s Object Browser (right), and you will have the benefit of Intellisense (below) while editing code that uses members of the Solver library” , I can see the classes, same as yours, but not the “Members of the VBA-Functions”, i.e. the functions SolverOk, SolverAdd, etc. Do you have any idea why is this so? Thank you very much for your time and congratulations again for the site!
Best wishes from Barcelona (Spain).

Hi Marti - Thanks for your note.

When you set a reference to SOLVER in a project, and the Object Browser is open, select the SOLVER library in the top dropdown of the Object Browser. This displays a list of only the SOLVER classes in the left hand list. VBA_Functions should be the last one listed. Selecting that class will show the functions in the list of members.

Hi Jon,
that is precisely the problem: when I select the SOLVER library in the top dropdown of the Object Browser it displays the list of the SOLVER classes in the left hand list and I can see the VBA_Functions at the end. But although I select that class, it does NOT show the functions in the list of Members. Consequently VB do not recognize any procedure related to Solver when I call it from a Macro. Nonetheless, I have just discovered something interesting (and even more strange for an absolute begginner like me!). The class Solver4 contains the same members as VBA_Functions though with another name: i.e., SolvAdd, SolvChange, and so on. When I use this “short-named” members, Solver can be called from my macro though when it finishes (after a SolvSolve instruction) there appears a dialog box that begins with
“Cell:[Solver.xla]Ecel4Functions!A1
Formula:
Start of solver cell.
[...]
asking you to continue, to halt, to do it step by step, etc. When I let it to continue and it finishes to calculate, the final Solver dialog box appears (that one with the options of answer, sensitivity, etc. reports) and everything finishes normally.;(
Anyway Jon: I do not want to bother you anymore. If it happens that you encounter the clue, I will be glad and thankfull! I will keep on
investigating what the h*ll is going on and if I find something I will tell you anyay just for you to know!
Thanks very much again for everything and your quick answer!

Hmmm, looks like a defect in your version of SOLVER. What version of Excel, what localization?

You can show or hide the dialogs you describe by setting the parameters of the VBA_Functions you call. I notice the functions in Solver4 have the same arguments as those in VBA_Functions. presumably the Solver4 functions behave the same way, so check my links for help on the VBA functions and their parameters, if I don’t have enough details in my web page.

[...] you can download and install Jon Peltier’s free Align Chart Dimensions utility. There are installation instructions on Jon’s [...]

Not really a comment, but a question.

I have Office 2003 installed and the forms I use for work is in Excel and we added an add-in to update a couple of forms.

When we added the add-in originally, it stay checked. BUT, the last few months, every time we open the form, we MUST go back and make sure the add-in is checked.

It never stays checked.

It USED to, but it no longer does.

Is there an easy way to fix my problem or will I just “ACCIDENTALLY” have to drop my computer in the ocean?

Any help on this would be FANTASTIC!

Butch -

This behavior points to one of two things that I can think of.

1. Excel isn’t shutting down properly, so it doesn’t remember add-ins that were installed during the session. If you manually customize the interface (add a custom button), does the customization appear next time you start up Excel?

2. There is some kind of IT policy that uninstalls some or all add-ins. If it happens on multiple computers, I would suspect something like this.

It might be something completely unrelated.

So is there a way to go about fixing it, or do I just keep applying the add in every time?

Butch -

Depends what the problem is. Shutdown errors are tricky to fix, IT problems are even more tricky, and it’s hard debugging computer problems via WordPress.