Running Java code from excel

Hi,

I have a large comprehensive program written in Java and I would like to incorporate the answer in Excel... is there any way I can call the Java program from Excel, execute it and record the answer on an excel spreadsheet?

Thanks,

mbrolass.

I believe you have to copy your .class file in <system folder>\java\trustlib, for example: c:\windows\java\trustlib and then call the object from VBA, for example, if you have a class to create a zip file, you can do:

Please Login or Register  to view this content.

I don't know anymore about it... I hope it can help.

Regards,
Antonio

Originally Posted by Mbrolass

Hi,

I have a large comprehensive program written in Java and I would like to incorporate the answer in Excel... is there any way I can call the Java program from Excel, execute it and record the answer on an excel spreadsheet?

Thanks,

mbrolass.

You can call Java from Excel using Obba. The addin allows to instantiate objects, call methods (on them) and retrieve values. Its also available for OpenOffice on other plattforms.