I have an app in VB w/ Excel that uses the Microsoft Solver feature. In order to ensure functionality of the Solver I run the line: Application.Run ("Solver.xla!Auto_Open") when starting up the program.
I have now discovered that for some reason, after running this line, a listbox (that is totally unrelated to the Solver) in the program isn't refreshing properly. For the life of me, I cannot figure out why Solver would be influencing the behavior of this listbox. Can anybody offer any type of explanation of what exactly the command Solver.xla!Auto_Open is really doing, so that I can maybe figure out how to deal with this?? It's a vague question but I'm looking for any insight, alternative, description, explanation, etc, whatsoever. Unfortunately, the command seems necessary to open up Solver.