next »

[.]

Hi

I am opening excel using  CALL UI.INTERFACE.FRONTCALL("STANDARD","EXECUTE",  [lv_excel, 0],[lv_res]).
I want to find out if there is function call that can check if excel is open already before  I try to open it ? I am reading data from a spreedsheet and the application keeps opening another excel instance each time so I would like check if excel is running already  .

Thanks
Bothwell

[Reuben B.]

Hi

I am opening excel using  CALL UI.INTERFACE.FRONTCALL("STANDARD","EXECUTE",  [lv_excel, 0],[lv_res]).
I want to find out if there is function call that can check if excel is open already before  I try to open it ? I am reading data from a spreedsheet and the application keeps opening another excel instance each time so I would like check if excel is running already  .

Thanks
Bothwell

Create a small script/shell etc in a language the front-end understands e.g. on Windows I'd typically use VB script, and then use FrontCall to execute that script.

Google will typically return a number of potential solutions/techniques.  A quick google search of 'is excel running' returned http://peltiertech.com/Excel/scripts.html which looked a promising starting point. 

[.]

Thanks Reuben.