I can not use my solver

Question

I can not use my solver

Lee Sedol 0

微信图片_20240413165114 I can't use my solver in EXCEL,and there is an another erorr about SolverCode.

what should i do? thanks

1 answer

Your answer

Answer 1

Emi Zhang-MSFT 29,996 Microsoft External Staff

Hi,

I suggest you try this method:

Open VBE (Alt+F11)
Go to Tools- Reference- make sure the Solver reference is set to SOLVER.XLAM (NOT *.DLL)
Then enable immediate code pane (Ctrl+G)
Copy and Paste: application.run "solver.xlam!auto_open"

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Lee Sedol 0 Reputation points

2024-04-17T12:17:45.64+00:00

Thanks for your answer!But after i did it your way,the problem was still there

Here shows:

After i pasted the order and "Enter",VBA shows that this command can't be run.

I'm convinced that i followed your Step123 correctly. So what should i do next?

And there's one thing i have to mention: My computer's system is x64

and before I ask for help, I try to use SOLVER in EXCEL 2021/2019/2016 (use Microsoft's uninstall to swithch versions). But its still unavailble.

In the Chinese Forum, I saw some having the same problems. Some say that Solver's code is too old to run in x64? But My friends' x64 computer can use Solver.

Waiting for your suggestion
Lee Sedol 0 Reputation points

2024-04-18T02:16:26.07+00:00

After Step 123, I enable the immediate code pane and pasted application.run "solver.xlam!auto_open" then ENTER. Theres an erorr reported : Unable to run the macro application.run "solver.xlam!auto_open".What should i do next?

Share via

I can not use my solver

1 answer

Your answer