Run Excel Macro from Java  
Author Message
darshit_rao





PostPosted: 2005-1-20 13:03:00 Top

java-programmer, Run Excel Macro from Java I want to run the macro present inside the excel sheet using the Java
code. Is is possible using Java code? Please help
 
Ann





PostPosted: 2005-1-20 13:40:00 Top

java-programmer >> Run Excel Macro from Java
"Darshit Rao" <email***@***.com> wrote in message
news:email***@***.com...
> I want to run the macro present inside the excel sheet using the Java
> code. Is is possible using Java code? Please help

Is that your real first name? (-_-) [smiley for the naysayers]
You can get the contents of an Excel cell easily enough
by using the Java Excel API.
The macro is probably vba code (this is my guess.)
You can then intrepret the vba code, getting/putting other cells as
necessary.


 
Heiner K點ker





PostPosted: 2005-1-20 20:55:00 Top

java-programmer >> Run Excel Macro from Java Darshit Rao wrote
> I want to run the macro present inside the excel sheet using the Java
> code. Is is possible using Java code? Please help


Try

Runtime.exec( "dos_prompt_command" );

--
Heiner Kuecker
Internet: http://www.heinerkuecker.de http://www.heiner-kuecker.de
JSP WorkFlow PageFlow Page Flow FlowControl Navigation: http://www.control-and-command.de
Java Expression Formula Parser: http://www.heinerkuecker.de/Expression.html
CnC Template Technology http://www.heinerkuecker.de/Expression.html#templ