Java and Excel

Greetings,

I'm looking for advice or even service/consulting from someone who has done this kind of task before.

I have an excel sheet that has embedded formulas and actually complex VB code. You can enter data in certain cells, hit the "run program" button and then see results of computation in certain cells.

I need someone to tell me how I can access this excel and execute VB code from a java application. Please note: I can read and write to excel, so that is not the issue. The big problem is is "running" the excel program which us VB code. I'm trying to do this in apache TOMCAT server.

I've searched and read that it can be done through JNI, but I'm unable to find something clearly defined or close.

I greatly appreciate your advice!

C.A.

[796 byte] By [AmbitionWeba] at [2007-10-2 3:18:54]