Check for open excel application

Started by ., November 21, 2008, 09:52:51 AM

Previous topic - Next topic

.

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.

Quote from: Bothwell Watadza on November 21, 2008, 09:52:51 AM
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. 
Product Consultant (Asia Pacific)
Developer Relations Manager (Worldwide)
Author of https://4js.com/ask-reuben
Contributor to https://github.com/FourjsGenero