VBA Solver Call -> Solver is missing or not installed properly

%3CLINGO-SUB%20id%3D%22lingo-sub-2440679%22%20slang%3D%22en-US%22%3EVBA%20Solver%20Call%20-%26gt%3B%20Solver%20is%20missing%20or%20not%20installed%20properly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2440679%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20been%20using%20Solver%20in%20Excel%20via%20a%20VBA%20macro%20call%20to%20run%20workbooks%2Fprograms%20for%20application%20to%20vehicle%20crash%20reconstruction.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20been%20using%20(the%20same)%20Excel%20Solver%20via%20a%20VBA%20call%20in%20a%20workbook%20for%20the%20last%2016%20years.%20In%20the%20last%20few%20weeks%20when%20I%20try%20this%20routine%2C%20I%20get%20an%20error%20that%20says%20%E2%80%9CSolver%20is%20missing%20or%20not%20installed%20properly%E2%80%9D.%20I%20verified%20this%20error%20on%20another%20computer%20using%20the%20same%20software%20and%20program.%20I%20also%20have%20verified%20that%20Solver%20IS%20included%20in%20the%20list%20of%20installed%20Add-Ins%20on%20these%20computers%20and%20these%20computers%20have%20run%20this%20program%20recently.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EAdditionally%2C%20on%20one%20of%20the%20computers%2C%20I%20uninstalled%20and%20reinstalled%20the%20software%20application%20that%20includes%20the%20program%20that%20has%20the%20VBA%20code%20and%20this%20did%20not%20solve%20the%20problem.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20suspect%20that%20some%20recent%20update%20to%20Office%20is%20the%20reason%20that%20this%20call%20to%20Solver%20in%20the%20VBA%20code%20is%20not%20working.%20I%20welcome%20advice%20on%20steps%20I%20can%20take%20to%20solve%20this%20issue.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2440679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have been using Solver in Excel via a VBA macro call to run workbooks/programs for application to vehicle crash reconstruction.

I have been using (the same) Excel Solver via a VBA call in a workbook for the last 16 years. In the last few weeks when I try this routine, I get an error that says “Solver is missing or not installed properly”. I verified this error on another computer using the same software and program. I also have verified that Solver IS included in the list of installed Add-Ins on these computers and these computers have run this program recently.

Additionally, on one of the computers, I uninstalled and reinstalled the software application that includes the program that has the VBA code and this did not solve the problem.

I suspect that some recent update to Office is the reason that this call to Solver in the VBA code is not working. I welcome advice on steps I can take to solve this issue.

0 Replies