Then you are to generate file you need with template containing your macros.
After it using java you can execute batch file that will open generated file in Excel.
But this is not good idea (IMHO). :)
You better find other way to accomplish you needs.
Best regards, Andrew.
----- Original Message ----- From: "Elsberry, Richard C - Eagan, MN - Contractor" <[EMAIL PROTECTED]>
To: "POI Users List" <[EMAIL PROTECTED]>
Sent: Wednesday, December 22, 2004 5:58 PM
Subject: RE: Rookie formula problem!
Andrew,
Your suggestion worked! After opening and resaving the excel doc manually I was able to read the calculated data.
However, my application is required to use a specific excel spreadsheet in the background as a calculator. I can't get around that. In addition, it is never accessible to the user who will enter data via a browser. So this resaving step will have to be done with my application. Is there a way to do this programmatically?
Thanks again for your assistance. Richard
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
