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

Emi Zhang-MSFT 21,856 Reputation points Microsoft Vendor

2024-04-15T01:53:44.3933333+00:00
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.
Please sign in to rate this answer.
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?
Sign in to comment