LinkBack URL
About LinkBacks
Hello all,,
I recorded a macro in Visual Basic. Used the solver. It won't run, saying Compile error: sub or Function not defined, and highlights the SOLVEROK part of the Macro. What is the issue here?
Thanks
Hello all,,
I recorded a macro in Visual Basic. Used the solver. It won't run, saying Compile error: sub or Function not defined, and highlights the SOLVEROK part of the Macro. What is the issue here?
Thanks
Last edited by LuisFQuintero; 09-25-2015 at 03:51 PM.
Hello LuisFQuintero,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
When browsing for "Solver.xlam" check that settings is for all files (*.*) default setting when searching for an add-in is "*.dll" and this will not find the "Solver.xlam" fileBefore you can use the Solver VBA functions in the Visual Basic Editor, you must establish a reference to the Solver add-in. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then select Solver under Available References. If Solver does not appear under Available References, click Browse, and then open Solver.xlam in the \Program Files\Microsoft Office\Office14\Library\SOLVER subfolder.
Alf
Ps Hi arlu long time no see! Nice to see you are back!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks