I'm working in re-engineering project where an application which is developed using VBA and macros need to be migrated to Java. The application is using SOLVER.XLA (a proprietary dll of microsoft) for optimization. We came to know that SOLVER.XLA is also available in the form of DLLs but not sure whether it wl be compatible for java environment as java supports APIs only. Pl let us know how to get the SOLVER.XLA equivalent for java.

Thanks in advance.