Solver reference

[emorris1000]

I'm trying to use Solver in an Excel template generated from access. I know the code (more or less), but I can't seem to find the reference for Solver. Only thread I found that mentions the reference here is this one:

http://www.access-programmers.co.uk/forums/showthread.php?t=91620&highlight=solver

Where he references Solver.Xla and Solver32.dll. I tried referencing Solver32.dll but it wouldn't let me ("Can't add a reference to the specified file").

Any thoughts? Still hunting online for a solution to this.

 

[emorris1000]

Quick update, I tried running regsvr32.exe on the dll and that didn't work either. I'm not sure if this is due to being on a company computer that has some strict rules on this thing or not.