The question is how to return a string from java method in VBA. For example I have a code in java:
package someclass;
public class SomeClass {
public static String someMethod(String s){
return "this is some string: "+s;
}
public static void main(String[] args) {
System.out.println(someMethod("Hello world!"));
}
}
Now the question is how to call someMethod in VBA?
Use Jinx, the Excel Java Add-In, to call your Java method as an Excel macro.
See https://exceljava.com for details.
All you would need to do in your example is to add the @ExcelMacro annotation to your method to make it callable from Excel as a macro.
package someclass;
import com.exceljava.jinx.ExcelMacro;
public class SomeClass {
@ExcelMacro
public static String someMethod(String s){
return "this is some string: "+s;
}
public static void main(String[] args) {
System.out.println(someMethod("Hello world!"));
}
}
See https://exceljava.com/docs/macros.html for more details about writing Excel macros in Java using Jinx.
Thanks to @mschwehl answer (i.e. possible solution) here:
stackoverflow.com/questions/11343769/
