Compile error: Can't find project or library

[scipio314]

Image of error. - reported by /u/zer0balance

[drew3770]

Had this error too. How can I overcome this and get this to work?

[scipio314]

I haven't been able to verify a solution. So if anyone has one please post. You can try the following:

I think what you need to do is add the correct references in Excel for your project to work. Here is how to do that:

1. Hit Alt + F11.
2. Go to "Tools" in the top ribbon.
3. Look at this picture and make sure all these boxes are checked. You may have to scroll down to find them all.

I'm on Excel 2010, by default later versions of Excel use different object libraries. I think it should just be a matter of adding an older version of excel's references. Let me know if this works.

[drew3770]

I have solver but not open solver. I’ll have to get open solver when I have time.

[KrazyEyes125]

Is this project still live? I hope so because I love what has been shown here.

[KrazyEyes125]

Mine started working after I tried opening the "Tools" option and making sure all boxes were checked that you said and none others. Everything was as it was supposed to be and when I tried running it again it worked somehow.

[scipio314]

@KrazyEyes125 yeah this project is still alive. I haven't made any updates in a while but the spreadsheet should (mostly) work. There are a couple quirks that need a fix.