Hi Brett. 2) is surely possible. The macro code from the template isn't lost.
1) wasn't possible some months ago and I don't think that this has changed up to yet. Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 11. Februar 2005 18:31 An: [email protected] Betreff: Writing VBA macros with POI I have an unusual request to be able to include a standard macro in dynamically generated Excel files that I stream from a J2EE application. Is it possible to either: 1) Create the file dynamically with POI and add in macro code at runtime? Or 2) Perhaps have a static template xls file with the macro code already in it which I would then copy into memory using POI (assuming POI doesn't damage or alter the macro code) and then manipulate the cells with the data that I then stream to the user for download? Thanks for any input. Brett --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
