VBA and solver addin Compile Error

[Cookstein2]

Hi Guys

I am trying to implement the solver addin using VBA. I am completely unfamiliar with this so i have started by recording a macro just so that i could see the structure of the code and the "key words"

I recorded the following macro,

Please Login or Register  to view this content.

Whilst recording it all works as expected but then when i go to run the macro it highlights the term "SolverOk" and gives me a compile error saying "Sub or Function not defined"

Could anyone help me out with what might be wrong

Thanks

EDIT:

Ok, the solver addin is installed (obviously) but there was no refernce to it in the VBA so the solver libray wasnt loaded.

So i have gone to Tools -> References and have then found the SOLVER32.DLL and tried to open it but i get an error message saying;

"Can't add a reference to the specified file"

Any ideas?

[StephenR]

When you go to the list of references don't you just have SOLVER in the list?

[Cookstein2]

ah yes, and that works fine. Thanks

Any ideas why it didnt work when browsing through to its home folder?

[romperstomper]

The reference needs to be set to the .xla file, not the dll.

[Cookstein2]

ah ok. When i hit browse it was automatically filtering for .dll files