I have a spreadsheet that uses solver. When pressing a "run" button on one of the spreadsheets, VBA comes up in error stating “'Compile error in hidden module:Module2'
This is because it is not recognizing where the Reference to Solver is located. It seems that different versions of excel have [login to view URL] located in different directories?
This spreadsheet will be sent to multiple users so it is important that all users can run the program successfully.
If so, how can we make it so that the reference is referenced to solver for different users.
I doubt that this is a very large problem at all, but if you can help and quote us a price for the services as soon as possible than that would be fantastic.
Cheers
Jonathan Lowe
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
All Exel 97 to recent. All windows operating systems.