Question: Problem in executing macro enabled excel sheet using java
I have written a java code which will read a excel sheet with macro enabled. then it will write data into sheet1 and sheet2 and it will execute a VB script to generate scripts to call different procedures in database. But when i am trying to execute VB script it is unable to execute macro and cannot generate the script file.
Please help me with a proper solution.