|
If I understand the original post correctly, then he has a some sophisticated functionality written in Java and he would like to access this functionality from excel.
While I would agree that you should use a macro (i.e., a vba sub) to control java, the solution to his problem could be to provide the required functionality as a user defined function. This function could be implemented in vba (as a vba function) or in C or C++ (as an XLL) or in Java. The additional functionality then is an add in (or plug in).
In the industry (e.g. finance) Excel is usually extended with add ins written in C or C++ or C# (xlls or dlls). The solution(s) I mentioned allow to extend excels FUNCTIONality via Java libraries.
|