search

scipio314 / draftKnight

draftKnight is an excel sheet that generates optimized fantasy football lineups for DraftKings
GNU General Public License v3.0
31 stars 13 forks source link

Compile error: Can't find project or library #5

Open scipio314 opened 8 years ago

scipio314 commented 8 years ago

Image of error. - reported by /u/zer0balance

drew3770 commented 7 years ago

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

scipio314 commented 7 years ago

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 commented 7 years ago

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

KrazyEyes125 commented 7 years ago

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

KrazyEyes125 commented 7 years ago

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 commented 7 years ago

@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.