How to call a macro from Java

[plsHelpMe]

Hello Everyone,

I am having a problem. Actually i am having a Macro(Excel), which is when run asks for few inputs and raw data and then give the analysed excel data at some location which is specified as an input to it.
Now, i want this macro to be executed from my java code. It would really be great if someone could help me on the same. Also please tell me how to specify the inputs needed by this macro while executing this from my java code. I am not sure if we have anything offered by POI for this.

TIA

[plsHelpMe]

Hi ALl,

I am able to call the macro using the Runtime.getRunT ime(), but can somebody tell me if i can pass the arguments also as this macro needs some inputs

Thanks

[Ramya28]

Hi ALl,

I am able to call the macro using the Runtime.getRunT ime(), but can somebody tell me if i can pass the arguments also as this macro needs some inputs

Thanks

hi,
Am also in the same need ...But i want to write a macro myself..using java..
Because 1000s of excel sheets will be generated and i want to save a single macro for them only during time of creation of the sheets.. and also by not opening the excell sheets manually.. Is it possible??

[jija]

From POI ,not possible to run excel macros ...!!!!