VBA, Java, Excel

1. Script for calling macro

http://pastie.org/pastes/3171814
save it as calling.vbs

in java you can call it as Runtime.getRuntime().exec("cmd /c start calling.vbs");

----------//---------------

2. for close excel:

ActiveWorkbook.Save

Application.DisplayAlerts = False

Application.Quit

3. Автоматический запуск макроса при открытии Excel.

Sub Auto_Open()

   Call <macros>

End Sub